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?

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
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