Forum Discussion
NomanMetaIT
Jan 31, 2024Copper Contributor
Dates are showing as 5 digit number in formula
Hi, I'm facing an issue with formula. I have a lot of dates in cells. I want to use them in formula using AND function. But when I enter the cell reference that contains the date, it converts dat...
- Jan 31, 2024
That is the way dates are stored in Excel (as a count of days since 01/01/1900). To reproduce the date with the formatting you require, use the TEXT function
= "Check Number:" & check & " was received on " & TEXT(date, "dd/mm/yyyy")
PeterBartholomew1
Jan 31, 2024Silver Contributor
That is the way dates are stored in Excel (as a count of days since 01/01/1900). To reproduce the date with the formatting you require, use the TEXT function
= "Check Number:" & check & " was received on " & TEXT(date, "dd/mm/yyyy")
NomanMetaIT
Jan 31, 2024Copper Contributor
Thank you Peter for a quick response. I was trying to figure out this issue on google/YouTube. But no resolution was found. You've made my day and saved a lot of time for me.