Download the example workbook
This tutorial will demonstrate how to use the IF Function with Dates in Excel and Google Sheets.
IF & DATE Functions
=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
If Function with Dates – Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.