How to calculate 90 days from current date in Excel?

Effortlessly Calculate 90 Days from Current Date in Excel

Excel provides a comprehensive solution for performing date calculations, including the ability to determine future dates quickly. By leveraging conditional formatting, users can conveniently identify cells representing a specific date in the future, making project management and scheduling tasks more streamlined.

To calculate 90 days from the current date in Excel, follow these simple steps:

1. Select Cells to Format: Choose the cells you wish to apply the conditional formatting to.

2. Conditional Formatting Menu: Go to the “Home” tab, then click “Conditional Formatting” and select “New Rule.”

3. Formula for Days Calculation: In the “New Formatting Rule” dialog box, select “Use a formula to determine which cells to format” under “Select a Rule Type.”

4. Formula Input: Enter the following formula into the “Format values where this formula is true” field:

   =TODAY() + 90

5. Choose Formatting: Click the “Format” button to determine the desired formatting, such as cell color or text style, to be applied to cells meeting the specified condition.

6. Apply: Click “OK” to apply the conditional formatting.

Now, cells whose dates are precisely 90 days in the future from the current date will be automatically highlighted with the chosen formatting. This dynamic approach allows you to easily identify deadlines, project milestones, and other important dates in your spreadsheet.

By utilizing conditional formatting and the TODAY() function, Excel empowers users to efficiently calculate future dates, simplifying scheduling and enhancing project management capabilities.