If Functions with Dates – Excel & Google Sheets

This tutorial will demonstrate how to use the IF Function with Dates in Excel and Google Sheets.

IF Dates Main Function

IF & DATE Functions

To use dates within IF Functions, you can use the DATE Function to define a date:

IF

One example of this formula is to calculate if a payment is over due:

Payment Over Due

Payment Overdue

If Function with Dates – Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

IF Dates Google

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!