Macro for date difference

Closed
nick - 6 Aug 2009 à 04:36
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Aug 2009 à 06:43
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Aug 2009 à 06:43
what is in A1 . is it an EXCEL DATE(MM/DD/YY)

COPY WHAT IS IS IN a1