Return to Excel Formulas List

If Functions with Dates – Excel & Google Sheets

Download Example Workbook

Download the example workbook

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:


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