Macro for date difference

Closed
nick - Aug 6, 2009 at 04:36 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 6, 2009 at 06:43 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 6, 2009 at 06:43 AM
what is in A1 . is it an EXCEL DATE(MM/DD/YY)

COPY WHAT IS IS IN a1
0