Previous Topic Next Topic

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
I have an Excel workbook with daily entries of my lunch and dinner meals. On a separate sheet, I'm counting the total number of occurrences of each meal. But I would also like to count the number of days its been since the last time I had a "sandwich", for example. This way I know what I haven't eaten in a while. Is there a way to do this?
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
1

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

2 responses
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

1 response
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses