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

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List