Excel - Counting number of days between two entries

Latest update on by aakai1056 .

Issue

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?

Solution

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

Note

Thanks to venkat1926 for this tip on the forum.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Counting number of days between two entries », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).