Combinig cells and getting date number instead of date

[Carlos5]

Hello,
I am using the following formula: ="Payroll (Start Date: " & Input!F1 & " End Date: " & Input!F2 & " ) "
The output is: Payroll (Start Date: 45732 End Date: 45745)
Is there a way to convert the date numbers to mm/dd/yy ?
Thank you,

 

[Micron]

Check the format of the cell and change it to what you need. Dates are floating point double data type IIRC, and 45732 is 3/16/2025. It represents the number of days since, I think, Dec. 31 1900 if you're not using 1904 option in Windows settings.

 

[PeteWright]

It seems your data isn't formatted as date. Try this formula:

="Payroll (Start Date: " & TEXT(Input!F1, "mm/dd/yy") & " End Date: " & TEXT(Input!F2, "mm/dd/yy") & " ) "

 

[Carlos5]

Check the format of the cell and change it to what you need. Dates are floating point double data type IIRC, and 45732 is 3/16/2025. It represents the number of days since, I think, Dec. 31 1900 if you're not using 1904 option in Windows settings.

Thank you, I changed the format of the cell but that did not work.

 

[Carlos5]

It seems your data isn't formatted as date. Try this formula:

="Payroll (Start Date: " & TEXT(Input!F1, "mm/dd/yy") & " End Date: " & TEXT(Input!F2, "mm/dd/yy") & " ) "

Thanks! That did it.

 

[Micron]

Thank you, I changed the format of the cell but that did not work.

From what little I know about Excel, it would seem that once data is entered, changing the cell format won't always change the way it looks so you have to enter it again. If that's true, it's awfully bizarre.