Excel date compare with system date
Closed
shani
-
Apr 21, 2010 at 01:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 07:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 07:23 AM
Related:
- Excel date compare with system date
- Excel date format dd.mm.yyyy - Guide
- Beyond compare - Download - File management
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 21, 2010 at 07:23 AM
Apr 21, 2010 at 07:23 AM
try this (assuming the date is in cell A2)
=TEXT(TODAY() - A2,"#")
=TEXT(TODAY() - A2,"#")