Excel - Counting number of days between two entries
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.
Related
- Excel - Counting number of days between two entries
- Count number of days between two entries? ✓ - Forum - Office Software
- Excel count name - Guide
- Excel count exclude zero and blank ✓ - Forum - Excel
- Excel count conditional formatting color cells - Forum - Excel
- Excel - Count 2 values in one column and 1 value in other - How-To - Excel
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).