Using an Excel Formula If the Date Is Greater Than 365 Days – 4 Examples

The dataset showcases projects and their End Dates.

To find if the End Date is greater than 365 days from the current date:

excel formula if date is greater than 365 days


Example 1 – Use the Excel TODAY Function to Show If a Date Is Greater Than 365 Days

STEPS:

  • Select D5 and enter the formula below:
=C5<(TODAY()-365)

Use Excel TODAY Function to Show If Date Is Greater Than 365 Days

Here, TODAY()-365 returns the date 29-08-21. If the date in C5 is less than this date, the formula will show TRUE. Otherwise, FALSE.

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Use Excel TODAY Function to Show If Date Is Greater Than 365 Days

This is the output.

Note: You can also use the formula below:

=DAYS(TODAY(),C5)>365

The End Dates must be prior to today. Here, the DAYS function returns the number of days between today’s date and C5.


Example 2 – Display a Specific Value If the Date Is Greater Than 365 Days with Excel Formula

STEPS:

  • Select D5 and enter the formula below:
=IF(C5<(TODAY()-365),"Greater Than 365 Days", "X")

Print Specific Value If Date Is Greater Than 365 Days with Excel Formula

If the condition is true, the output of this formula will be Greater Than 365 Days. Otherwise, it will show X.

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Print Specific Value If Date Is Greater Than 365 Days with Excel Formula

This is the output.


Example 3 – Check If the Difference Between Two Dates Is Greater Than 365 Days with a Formula in Excel

Check If Difference Between Two Dates Is Greater Than 365 Days with Formula in Excel

 

STEPS:

  • Select E5 and enter the formula below:
=DAYS(D5,C5)>365

Check If Difference Between Two Dates Is Greater Than 365 Days with Formula in Excel

The DAYS function finds the number of days between two days. The first argument is the start date and the second argument the end date. After finding the number of days, the formula checks if the result is greater than 365. If the difference is greater than 365 days, it will show TRUE. Otherwise, FALSE.

  • Press Enter.
  • Drag down the Fill Handle to see the result in the rest of the cells.

Check If Difference Between Two Dates Is Greater Than 365 Days with Formula in Excel

This is the output.


Example 4 – Applying the Excel Conditional Formatting with a Formula to Show If the Date Is Greater Than 365 Days

STEPS:

  • Select C5:C9.

Apply Excel Conditional Formatting with Formula to Show If Date Is Greater Than 365 Days

  • Go to the Home tab and select Conditional Formatting.
  • Select New Rule.

Apply Excel Conditional Formatting with Formula to Show If Date Is Greater Than 365 Days

  • In the New Formatting Rule box, select ‘Use a formula to determine which cells to format’ in Select a Rule Type.
  • Enter the formula in ‘Format Values where this formula is true’ :
=C5<(TODAY()-365)
  • Click Format.

Apply Excel Conditional Formatting with Formula to Show If Date Is Greater Than 365 Days

  • In the Format Cells window, click Fill and choose a color from Background Color.
  • Click OK .

Excel will highlight cells that contain dates greater than 365 days from today.


Download Practice Book

Download the practice book.


 

<< Go Back to Dates | Compare | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo