81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

DATE()

Description

Converts a provided year, month, and day into a date.

How To Use in Sheets

DATE(year, month, day)

External Links

1Better Sheets Tutorial

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.