Count number of days between two entries?
Solved/Closed
SP
-
Jan 28, 2010 at 01:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2010 at 08:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2010 at 08:46 PM
Related:
- Count number of days between two entries?
- Skype last seen days ago - Guide
- Time of day clock stopped - Guide
- Move files older than x days windows - Guide
- How to count names in excel - Guide
- Add 90 days to a date - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 28, 2010 at 08:46 PM
Jan 28, 2010 at 08:46 PM
suppose date of sandwich was 12/1/2009(1st December 2009)
suppose it is in A1
in any other cell if you type the formula
=TODAY()-A1
and you format this cell as number then you get 59 that is 59 days since you had sandwich
suppose it is in A1
in any other cell if you type the formula
=TODAY()-A1
and you format this cell as number then you get 59 that is 59 days since you had sandwich
