Dec 26 2023 01:48 PM - edited Dec 26 2023 01:51 PM
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!
Dec 26 2023 02:01 PM
="- 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.
Dec 26 2023 02:07 PM