Do you wish to know what the date will be some days from today? I'm sure you might wonder about an expiration date after a specified number of days.
Or you may desire to know what the date will be for some days before today. Maybe you wish to know the date of the day that occurred 50 days before today.
Anyhow it is, excel got you covered. You can quickly calculate the date by using the date calculator on excel.
This tutorial will guide you on calculating the date for any number of dates from or before. It doesn't take much time, so kindly spare the next few minutes to peruse this tutorial.
How to calculate 90 days from today in Excel
You can find the date of Nth days from any date by using the "today function". The function will display the number of days for the current day, and you have to add the number of days that you wish to calculate the date for.
1. Select the first column
2. Click on the Format dropdown and select format cells
3. Select date and click ok
4. Now, If you wish to calculate the date of the day that occurs 30 from today, use this function:
5. Now, If you wish to calculate the date of the day that occurs 60 from today, use this function:
6. I'm sure you don't need further explanation on how to calculate the date for 90 days from today.
You can create a generic formula for today plus any number of days. Type the number of days in a selected cell and add it to the current date.
Supposing, we are working on cell B3:
With this, you can quickly type any number of days in the string, and the date will be calculated automatically
Calculating the date for any number of days before today is as simple as the one we discussed above.
In this case, the number of days is subtracted from the current date.
You can calculate the date for a day, 90 days before today by using the formula:
You can create a generic formula for today, minus any number of days. Please type the number of days in a selected cell and add it to the current date.
I hope this tutorial was helpful. Thanks for reading!