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
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.
please help me out.
Related:
- Excel date compare with system date
- Excel date format dd.mm.yyyy - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Beyond compare download - Download - File management
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
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,"#")
