Table of Contents
To calculate 90 days from a given date in Excel, you can use the DATE function along with the addition operator. The DATE function takes three arguments: year, month, and day. By adding 90 to the day argument, you can get the date that is 90 days after the given date. For example, if the given date is January 1, 2021, the formula would be =DATE(2021,1,1)+90, which would result in April 1, 2021. Another way to do this is by using the EDATE function, which allows you to add or subtract a specified number of months to a given date. For example, the formula =EDATE(“1/1/2021”,3) would also result in April 1, 2021. Both methods can be useful for calculating future dates or tracking deadlines in Excel.
You can use the following formulas in Excel to calculate the date that is 90 days from a specific date:
Method 1: Calculate 90 Days from Specific Date
=A2+90
This particular example will return the date that is 90 days after the date in cell A2.
Method 2: Calculate 90 Business Days from Specific Date
=WORKDAY(A2, 90)
This particular example will return the date that is 90 business days after the date in cell A2.
Note: Business days only include the days between Monday and Friday.
The following examples show how to use each method in practice with the following list of dates in Excel:
Example 1: Calculate 90 Days from Specific Date
We can type the following formula into cell B2 to return the date that is 90 days after the date in cell A2:
=A2+90
We can then click and drag this formula down to each remaining cell in column B:
Each cell in column B displays the date that is 90 days after the corresponding date in column A.
For example:
- 90 days after 1/1/2024 is 3/31/2024.
- 90 days after 1/5/2024 is 4/4/2024.
- 90 days after 2/17/2024 is 5/17/2024.
And so on.
Example 2: Calculate 90 Business Days from Specific Date
We can type the following formula into cell B2 to return the date that is 90 business days after the date in cell A2:
=WORKDAY(A2, 90)
We can then click and drag this formula down to each remaining cell in column B:
Each cell in column B displays the date that is 90 business days after the corresponding date in column A.
For example:
- 90 business days after 1/1/2024 is 5/6/2024.
- 90 business days after 1/5/2024 is 5/10/2024.
- 90 business days after 2/17/2024 is 6/21/2024.
And so on.
Note #1: If the formula returns a numeric value then you need to click the Number Format dropdown menu on the Home tab along the ribbon and then click Short Date to format the number as a date.
Note #2: You can find the complete documentation for the WORKDAY function in Excel .
Additional Resources
The following tutorials explain how to perform other common operations in Excel: