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 the date:


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