How to Calculate 90 Days from a Specific Date in Excel

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often face a situation when we need to calculate a date that is exactly 90 days away from a specific date. If you are wondering how to do that you have come to the right place. In this article, I will show how to calculate 90 days from a specific date in Excel.


How to Calculate 90 Days from a Date in Excel: 2 Useful Methods

In this section, we will demonstrate 2 effective methods to calculate 90 days from a specific date in Excel. To illustrate, I have taken a dataset where we have some dates in a column. In another column, we will try to calculate the date which is 90 days away from the date on the left column.

how to calculate 90 days from date in excel

Let’s look at the first method to accomplish our goal.


1. Application of SUM Function to Calculate 90 days from a Specific Date in Excel

In the first method, we will use the SUM function to calculate the date after 90 days. The SUM function will just sum 90 with the specific date provided in the column.

Steps:

  • First, write down the following formula in cell D5 and press Enter. You will have the result like this.
=SUM(B5:C5)

Application of SUM Function to Calculate 90 days from a Specific Date in Excel

  • 90 days after 10 February 2022 will be 11 May 2022.
  • Now, use the Fill Handle to autofill the formula in the rest of the cells. Our final result will be like this.

We can see from the figure, that each calculated date is exactly 90 days away from the specified dates in the left column.

Read More: Excel Calculates Difference Between Two Dates in Days


2. Calculation of 90 days from a Specific Date in Excel by Using the Arithmetic Operator(+)

Instead of using the SUM function, we can use the mathematical operator Plus (+) to add 90 to the given date.

Steps:

  • Write down the following formula in cell D5 and press Enter. You will have a similar result to method 1.
=B5+C5

Calculation of 90 days from a Specific Date in Excel by Using the Arithmetic Operator(+)

  • After that, we will use the Fill Handle to auto-fill the rest of the cells to get our final result.

Read More: Excel Formula to Calculate Number of Days Between Today and Another Date


How to Calculate the Date 90 Days Before or After

Sometimes we may need to calculate a date that is either 90 days after or before a specified date. In this section, I will discuss how we can calculate the date 90 days before or after a particular date. To do that, follow the steps below.

Steps:

  • In the previous method, I added 90 with the given date to calculate the date after 90 days using the following formula.
=B5+C5
  • After that, we auto-fill the rest of the cell to get dates after 90 days.

How to Calculate the Date 90 Days Before or After

  • Similarly, we will now subtract 90 to get the date before 90 days by using the following formula.
=B5-C5

  • Now, if you autofill the rest of the cells using the Fill Handle then you will get the complete result.

How to Calculate the Date 90 Days Before or After

  • If we need to calculate the date that is 90 days after today, we can use the TODAY function to do this.
=TODAY()+90

How to Calculate the Date 90 Days Before or After

As the article was written on 16-11-22, the date after 90 days will be 14-02-23. As TODAY is a dynamic function, it will always update the date when any change occurs.

Read More: How to Calculate Remaining Days in Excel


How to Calculate 90 Workdays in Excel

On many occasions, we need to calculate a date that is not 90 days after a particular date but rather after 90 official days. This is usually the case when dealing with official datelines that exclude public holidays and weekends. Hence, in this case, we need to use a special function like the WORKDAY function. To illustrate, I have taken a list of dates and on the right column, we will calculate the dates following 90 workdays.

How to Calculate 90 Workdays

To do that, follow the steps below.

Steps:

  • Firstly, write down the formula in cell C5 and click Enter. You will have the following result.
=WORKDAY(B5,90)

  • If we compare the result with the previous one, we will notice that in earlier cases when only workdays were not counted, the result was 11 May-22, not 16-Jun-22.
  • Now, use the Fill Handler to auto-fill the rest of the cells.

How to Calculate 90 Workdays

Read More: How to Calculate Overdue Days in Excel


Things to Remember

  • If your result is not showing in the proper date format, you have to change the format of the cells to your desired date format.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

That is the end of this article. If you find this article helpful in understanding how we can calculate 90 days from date in Excel, please share this with your friends. Moreover, do let us know if you have any further queries. Goodbye!


Related Articles


<< Go Back to Days Between Dates | Calculate Dates | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo