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
- Count number of occurrences in excel - Guide
- Count names in excel - Guide
- Excel add days to date - Guide
- Time of day clock stopped - 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
