Calculate 90 Days From Date In Excel: Easy Steps!

6 min read 11-15-2024

Calculate 90 Days From Date In Excel: Easy Steps!

Calculating a date 90 days from a specific starting point in Excel can be quite straightforward once you understand the right functions to use. Whether you're tracking project deadlines, analyzing data timelines, or simply planning events, Excel has you covered. In this article, we'll walk through some easy steps and tips to calculate 90 days from any given date in Excel. Let’s dive in! 📅

Understanding Date Functions in Excel

Excel provides various functions to manipulate dates and times effectively. The two main functions we'll focus on are:

TODAY(): This function returns the current date.
DATE(): This function creates a date from specified year, month, and day values.

Why Calculate 90 Days?

Calculating 90 days can be useful in numerous scenarios:

Project Management: Keeping track of project milestones.
Financial Analysis: Setting payment terms or interest periods.
Health Tracking: Following up on treatment plans.

Easy Steps to Calculate 90 Days From a Date

Here’s how you can easily calculate a date that is 90 days from another date in Excel:

Step 1: Enter Your Starting Date

Open Excel and create a new spreadsheet.
In cell A1, enter your starting date. For example, you can type 01/01/2023.

Step 2: Use the Formula to Calculate 90 Days Later

In cell B1, enter the following formula:
```
=A1 + 90
```

This formula simply adds 90 days to the date in cell A1. 📈

Step 3: Formatting Your Date

Ensure that the result in cell B1 is formatted correctly as a date. To do this:

Right-click on cell B1.
Select Format Cells.
Choose Date from the category list and select your preferred date format.

Example of the Calculation

Here’s a quick example of how this looks in a table:

<table> <tr> <th>Starting Date</th> <th>Date After 90 Days</th> </tr> <tr> <td>01/01/2023</td> <td>04/01/2023</td> </tr> <tr> <td>02/15/2023</td> <td>05/16/2023</td> </tr> <tr> <td>03/10/2023</td> <td>06/08/2023</td> </tr> </table>

Using TODAY() Function for Dynamic Dates

If you want to calculate 90 days from today’s date dynamically, you can use the TODAY() function. Here’s how:

In cell A1, simply enter:
```
=TODAY()
```
In cell B1, use the same formula as before:
```
=A1 + 90
```

This setup will automatically update the starting date each day. For instance, if today is January 1, 2023, the result in B1 would show April 1, 2023. 🗓️

Important Note

When using the DATE() function, make sure to avoid common pitfalls such as entering an incorrect month or day number that doesn't exist. For example, there is no 30th day in February. Always double-check your dates! ❗

Other Useful Date Functions in Excel

Excel offers a variety of other functions that can further enhance your date calculations:

EDATE(start_date, months): This function returns a date that is a specified number of months before or after a starting date.
EOMONTH(start_date, months): This function returns the last day of the month that is a specified number of months before or after a starting date.
DATEDIF(start_date, end_date, "d"): This function calculates the difference between two dates in days, months, or years.

Conclusion

Calculating 90 days from a specific date in Excel is a simple process that can greatly aid in planning and managing various tasks. Whether you are dealing with project deadlines, analyzing financial data, or managing personal schedules, Excel's powerful functions allow you to handle date calculations with ease.

So, the next time you need to find a date 90 days from now or any other specific point, remember these steps and tips! With just a few clicks, you can streamline your date management in Excel, saving you time and effort. Happy calculating! 🎉