Adding 90 days to a date in Excel is super simple and incredibly useful. Whether you’re managing project timelines, tracking deadlines, or just curious about future dates, you can easily calculate this in a few steps. By using Excel’s built-in date functions, you can add 90 days to any given date without breaking a sweat.
Adding 90 Days to a Date in Excel
In this section, we’ll cover a step-by-step guide to adding 90 days to a date in Excel. By following these steps, you will learn how to use Excel’s functions effectively to perform date calculations.
Step 1: Open Your Excel Spreadsheet
First, open the Excel spreadsheet where you want to add 90 days to a date.
If you don’t already have a spreadsheet open, create a new one. Make sure you have some dates to work with or enter a new date in any cell.
Step 2: Enter a Date in a Cell
In a selected cell, enter the date you want to start with (e.g., "01/01/2023").
Ensure you enter the date correctly in a recognizable format (MM/DD/YYYY or DD/MM/YYYY, depending on your regional settings).
Step 3: Select a New Cell for the Result
Click on another cell where you want the new date (90 days later) to appear.
Choosing a separate cell for the result keeps your spreadsheet organized and prevents overwriting your original data.
Step 4: Use the Formula =DATE(YEAR(A1),MONTH(A1),DAY(A1)+90)
In your selected cell, type the formula =DATE(YEAR(A1),MONTH(A1),DAY(A1)+90), replacing "A1" with the cell reference containing your original date.
This formula breaks down the date into its components (year, month, day) and then adds 90 to the day part, creating a new date.
Step 5: Press Enter
Press Enter to calculate the new date.
Excel will automatically compute the new date and display it in your selected cell.
Once you’ve completed these steps, Excel will display a date that is 90 days after your original date. This method is efficient and ensures accuracy without manual counting.
Tips for Adding 90 Days to a Date in Excel
- Always double-check your date format to avoid errors.
- Use absolute cell references (e.g., $A$1) if you plan to copy the formula to other cells.
- Utilize Excel’s DATE function to manage complex date calculations easily.
- Remember to format the result cell as a date if it doesn’t display correctly.
- Practice using different date functions like EDATE or WORKDAY for varied date calculations.
Frequently Asked Questions
How do I format the date in Excel?
To format the date, right-click on the cell, choose "Format Cells," and select the "Date" category. Pick your desired date format from the list.
Can I add more than 90 days to a date?
Yes, you can add any number of days by modifying the formula. Replace the "90" with the desired number of days.
What if the date is in a different cell?
Adjust the formula to reference the correct cell. For example, if your date is in B2, use =DATE(YEAR(B2),MONTH(B2),DAY(B2)+90).
How do I handle dates across different months?
Excel’s DATE function automatically adjusts for month lengths, so you don’t need to worry about it.
Can I subtract days from a date?
Yes, you can subtract days by using a negative number. For example, =DATE(YEAR(A1),MONTH(A1),DAY(A1)-90) subtracts 90 days.
Summary
- Open your Excel spreadsheet.
- Enter a date in a cell.
- Select a new cell for the result.
- Use the formula =DATE(YEAR(A1),MONTH(A1),DAY(A1)+90).
- Press Enter.
Conclusion
Adding 90 days to a date in Excel is a handy skill that can save you loads of time. With just a few simple steps, you can easily perform this calculation and manage your dates more effectively. Excel’s DATE function makes it straightforward, ensuring you avoid manual errors and stay organized.
Now that you’ve mastered this task, consider exploring other date functions in Excel like EDATE for monthly calculations or WORKDAY to exclude weekends. The possibilities are endless, and each function can provide valuable insights, making your work smoother and more efficient.
So, go ahead and experiment with these functions. The more you practice, the more proficient you’ll become. If you found this guide helpful, share it with your friends or colleagues who might benefit from learning how to add 90 days to a date in Excel. Happy calculating!
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.