Your IT Consultant
Information Technology Blog
by John W. Simek, Vice President of Sensei Enterprises, Inc.
Math to Add or Subtract Dates in Excel
July 1, 2021
Ever want to know how many days there are from a certain date? How about finding out what the 137th day of the year is? You can always ask Google or do some date calculation with Microsoft Excel. How-To Geek has a post with instructions to perform date calculations. The basic principle is to create three columns for the date calculations. In the first column, put in your base date such as a due date or deadline. The second column is for the number of days you want to add or subtract. The third column is the result.
The post details how to format the cells and what formulas to use. You can add or subtract days, months or even years. The post also has a link to instructions for calculating the days between two dates.