Macro for date difference

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I am using

A1-Today()

to see the difference between the value and today date

however i am geeting the value as #NAME?


what is the reason?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
what is in A1 . is it an EXCEL DATE(MM/DD/YY)

COPY WHAT IS IS IN a1