Excel Guides

Tombstone Date Math in Excel

Tombstone date math in Excel can be a bit tricky. Here are some tips to help you get the most accurate results:

  1. Make sure your dates are entered in the correct format. The most common format is YYYY-MM-DD, but you can also use DD/MM/YYYY or MM/DD/YYYY. If your dates are in a different format, you may need to change the cell format.
  2. If you're subtracting two dates, make sure the first date is the older one. Otherwise, you'll end up with a negative number.
  3. To get the number of days between two dates, use the DAYS function. For example, if your start date is in cell A1 and your end date is in cell A2, you would enter =DAYS(A2,A1) into cell A3.
  4. To get the number of months between two dates, use the MONTHS function. For example, if your start date is in cell A1 and your end date is in cell A2, you would enter =MONTHS(A2,A1) into cell A3.
  5. To get the number of years between two dates, use the YEARS function. For example, if your start date is in cell A1 and your end date is in cell A2, you would enter =YEARS(A2,A1) into cell A3.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.