Excel Tutorial: How To Calculate 90 Days From Date In Excel

Introduction


Calculating 90 days from a date in Excel can be crucial for various business and personal finance purposes. Whether it's for tracking payment deadlines, planning project timelines, or simply managing schedules, knowing how to perform this task efficiently can save time and prevent errors. In this tutorial, we will provide a brief overview of the steps involved in the process to help you master this essential Excel skill.


Key Takeaways


  • Understanding the importance of calculating 90 days from a date in Excel for business and personal finance purposes
  • Learning the DATE function in Excel and its significance in date calculations
  • Mastering the process of adding 90 days to a specific date using Excel formulas
  • Handling leap years and month-end dates while calculating 90 days from a date
  • Utilizing the calculated date in other formulas and analysis for financial and project purposes


Understanding Date Functions in Excel


Excel offers a range of powerful date functions that allow users to easily manipulate and calculate dates. Understanding these functions can help streamline your workflow and make complex date calculations a breeze. In this tutorial, we will cover the DATE function, as well as provide an overview of other relevant date functions like TODAY and EDATE.

A. Explanation of the DATE function in Excel

The DATE function in Excel is used to create a date from individual year, month, and day components. It takes three arguments: year, month, and day, and returns a serial number representing the date. For example, to create the date January 1, 2022, you would use the formula =DATE(2022, 1, 1).

B. Overview of other relevant date functions like TODAY and EDATE

1. TODAY: The TODAY function returns the current date. It does not require any arguments and automatically updates to the current date whenever the spreadsheet is recalculated. For example, =TODAY() will return the current date.

2. EDATE: The EDATE function allows users to calculate a date that is a specified number of months before or after a given date. It takes two arguments: the start date and the number of months to add or subtract. For example, =EDATE("1/1/2022", 3) will return April 1, 2022.


Calculating 90 Days from a Specific Date


When working with dates in Excel, it's important to be able to perform calculations to determine future or past dates. One common calculation is determining a date that is 90 days from a specific date. Here's how you can do it:

A. Using the DATE function to add 90 days to a given date

The DATE function in Excel allows you to create a date by providing the year, month, and day as arguments. You can use this function to calculate a date that is 90 days after a specific date.

Steps:


  • Start by entering the original date in a cell, for example, A1: 10/15/2022
  • In another cell, enter the formula to calculate 90 days from the original date: =A1 + 90
  • This will display the date that is 90 days after the original date: 01/13/2023

B. Demonstrating the use of cell references for flexibility

Instead of manually entering the date and the calculation into the formula, you can use cell references to increase flexibility and make the formula easier to update.

Steps:


  • Enter the original date in one cell, for example, A1: 10/15/2022
  • In another cell, enter the formula to calculate 90 days from the original date using a cell reference: =A1 + 90
  • Now, if you need to change the original date, you only need to update the value in cell A1, and the formula will automatically recalculate the date that is 90 days from the new date.


Handling Leap Years and Month-End Dates


When calculating 90 days from a given date in Excel, it's important to consider the impact of leap years as well as month-end dates. This ensures accurate and precise calculations.

A. Addressing the impact of leap years on date calculations
  • Understanding leap years:


    Leap years, which occur every four years, have an additional day (February 29th) compared to non-leap years. This can affect date calculations if not accounted for.
  • Adjusting for leap years:


    When calculating 90 days from a given date, it's essential to account for any leap years within that time frame. This ensures the accuracy of the calculation.

B. Explaining the use of EDATE function to consider month-end dates
  • Handling month-end dates:


    When calculating 90 days from a given date, it's important to consider month-end dates. This ensures that the calculation accurately reflects a 90-day period.
  • Using the EDATE function:


    The EDATE function in Excel allows you to calculate a date that is a specified number of months before or after a given date. This can be useful for considering month-end dates in date calculations.


Formatting the Result


Once you have calculated the 90 days from a specific date in Excel, it's important to ensure that the result is displayed in a clear and understandable format. Here, we will discuss the various date formats available in Excel and provide tips on selecting the appropriate format for the calculated date.

A. Discussing the various date formats available in Excel
  • Date Formats: Excel offers a range of date formats including Short Date, Long Date, Time, and Custom formats. Each format has its own unique way of displaying the date.
  • Custom Format: With the Custom format option, you can also create your own date format using a combination of day, month, and year codes.

B. Providing tips on selecting the appropriate format for the calculated date
  • Consider the Context: When selecting a date format for the calculated 90 days, consider the context in which the date will be viewed. For example, if the date is part of a financial report, a standard Short Date format might be suitable.
  • Clarity and Readability: Choose a format that is clear and easily readable for anyone viewing the spreadsheet. Avoid overly complex date formats that may cause confusion.
  • Consistency: Ensure that the chosen date format aligns with the overall formatting of the spreadsheet to maintain consistency and professionalism.


Using the Result in Formulas and Analysis


Once you have calculated the 90-day date in Excel, you can use this result in various formulas and analysis to make informed decisions.

Illustrating how the calculated date can be used in other formulas


  • Date Functions: You can use the calculated 90-day date in conjunction with other date functions, such as calculating the difference between two dates or determining the end date of a project.
  • Conditional Formatting: You can use the 90-day date as a reference point for conditional formatting rules, such as highlighting cells that are approaching the 90-day mark.
  • Charting and Graphing: The 90-day date can be used as a data point in charts and graphs to visualize trends and patterns over time.

Highlighting the relevance of the 90-day date in financial and project analysis


  • Financial Planning: In financial analysis, the 90-day date can be used to track payment deadlines, evaluate cash flow projections, and monitor account receivables and payables.
  • Project Management: The 90-day date is crucial in project management for setting milestones, tracking progress, and assessing the timeline for completing tasks and deliverables.
  • Risk Assessment: By using the 90-day date as a reference point, you can identify potential risks and opportunities in business operations, investment strategies, and resource allocation.


Conclusion


By using the DATE and EDATE functions in Excel, you can easily calculate 90 days from a given date. Simply input the original date, and use the EDATE function to add 3 months, then the DATE function to subtract 1 day. Encouraging readers to practice this process and explore further applications of date functions, as Excel offers a wide range of functions to manipulate and analyze dates.

Excel Dashboard

ONLY $99
ULTIMATE EXCEL DASHBOARDS BUNDLE

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles