Forum Discussion
adding a date cell to a formula
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="&TEXT(W2,"DD.MM.YYYY")
This works if i correctly understand what you want to do.
- It did!! thanks figured i was just using the wrong formula!
