Calculate 90 Days From Date In Excel: Easy Steps Guide
Table of Contents :
Calculating a date that is 90 days from a specific date in Excel can be a straightforward task, especially when you know the right functions and steps to follow. Whether you're planning a project timeline, tracking due dates, or managing schedules, mastering this skill can greatly enhance your productivity. In this guide, we’ll walk you through the easy steps to calculate 90 days from a given date in Excel, along with some tips and tricks to help you along the way. 📅
Understanding Date Functions in Excel
Excel is equipped with a variety of date functions that can help you manipulate and perform calculations based on dates. The primary function that we will use for calculating days is the EDATE function and simple addition. Here’s a brief overview of these functions:
EDATE Function
The EDATE function can be utilized to add a specific number of months to a given date, which is very useful for project management scenarios where dates are crucial.
Adding Days Directly
Alternatively, you can simply add the number of days to the original date using arithmetic. This is particularly handy for straightforward calculations, such as adding 90 days.
Step-by-Step Guide to Calculate 90 Days from Date
Let’s go through the process step-by-step.
Step 1: Enter Your Starting Date
First, open your Excel worksheet where you want to perform the calculation. Click on the cell (e.g., A1) and enter your starting date. Make sure to input it in a recognized date format (e.g., MM/DD/YYYY).
Step 2: Use the Formula to Calculate 90 Days From the Date
In the next cell (e.g., B1), you can enter one of the following formulas:
-
Using Simple Addition:
=A1 + 90 -
Using EDATE Function:
=EDATE(A1, 3)Note: The
EDATEfunction above will add three months instead of 90 days. If you specifically want to calculate days, stick with the simple addition method.
Step 3: Format the Resulting Cell
If the result does not display in a date format, you may need to format the cell. To do this:
- Right-click on the cell with the resulting date (B1).
- Select "Format Cells."
- Choose the “Date” category and select your desired date format.
- Click “OK.”
Step 4: Drag to Auto-Fill (Optional)
If you have multiple starting dates in column A, you can easily calculate 90 days for all of them. Simply click on the bottom right corner of the cell with the formula (B1) and drag it down to fill in the other cells in the column.
<table> <tr> <th>Starting Date</th> <th>90 Days From Date</th> </tr> <tr> <td>01/01/2023</td> <td>03/02/2023</td> </tr> <tr> <td>02/15/2023</td> <td>05/16/2023</td> </tr> <tr> <td>07/10/2023</td> <td>10/08/2023</td> </tr> </table>
Additional Tips for Working with Dates in Excel
Be Mindful of Leap Years
When calculating dates, keep in mind the leap years which can affect your calculations. For instance, if your starting date is near February 29, the addition may push the result into March.
Handling Date Formats
Excel can sometimes interpret dates incorrectly based on regional settings. Ensure your computer’s date format matches the input format in Excel to avoid confusion.
Using Conditional Formatting
To highlight dates that are close or past due, you can set up conditional formatting. For example, you could format dates that are within a week of today’s date to appear in red.
Conclusion
Calculating 90 days from a date in Excel is a valuable skill that can simplify various planning and scheduling tasks. By using simple addition or the EDATE function, you can easily manage and manipulate date data effectively. Remember to always check your date formats, and don’t hesitate to make use of Excel's rich features to enhance your efficiency! Happy Exceling! 🎉