adding a date cell to a formula

Copper Contributor

i have what i think should be an easy one, i have a formula to display information from multiple cells in to a single cell using the &, when i add the date cell (W2) it converts it to decimal form.:

 

="- Expansion at Existing Location - General Personnel (Management Areas) - "&K2&" Site"&"
- On Track"&"
-SqFt= "&AF2&", Seats= "&AG2&", Conf Rm= 0, Due Date="&W2

 

What can i do to show the actual date in the cell in my formula?

 

Thanks!

2 Replies

@prometheis2000 

="- Expansion at Existing Location - General Personnel (Management Areas) - "&K2&" Site"&"
- On Track"&"-SqFt= "&AF2&", Seats= "&AG2&", Conf Rm= 0, Due Date="&TEXT(W2,"DD.MM.YYYY")

 

This works if i correctly understand what you want to do.

adding date cell to a formula.png

It did!! thanks figured i was just using the wrong formula!