If Functions with Dates – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
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

AI Formula Generator

Try for Free

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