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.

Email:  Phone: 703.359.0700
Digital Forensics/Cybersecurity/Information Technology