Excel date compare with system date

Closed
shani - Apr 21, 2010 at 01:09 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 21, 2010 at 07:23 AM
i want to compare a any date with system date, and to expect result in number,the no of days in them??
please help me out.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Apr 21, 2010 at 07:23 AM
try this (assuming the date is in cell A2)

=TEXT(TODAY() - A2,"#")
0