Count number of days between two entries?

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month