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

IF & DATE Functions

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

=IF(B3 > DATE(2020,1,1),"Delay","Ontime")


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