Forum Discussion

prometheis2000's avatar
prometheis2000
Copper Contributor
Dec 26, 2023

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="&W2

 

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

 

Thanks!

Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 26, 2023

    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.

    • prometheis2000's avatar
      prometheis2000
      Copper Contributor
      Dec 26, 2023
      It did!! thanks figured i was just using the wrong formula!

Resources