Forum Discussion

NomanMetaIT's avatar
NomanMetaIT
Copper Contributor
Jan 31, 2024
Solved

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...
  • PeterBartholomew1's avatar
    Jan 31, 2024

    NomanMetaIT 

    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")

Resources