What it does: The DATE() formula returns the serial number that represents a particular date.
Plain English: This formula returns the serial number of the year, month, and date provided.
- Year – What year?
- Month – Which month?
- Day – What day?
Blog Posts using DATE()
Videos using DATE()
What it does: The DAYS() function returns the number of days in between two dates
Plain English: In your data cleaning journey, you may need to check how much time has passed in between two dates or whether or not a certain AMOUNT of time has passed between two dates (Has it been at least one month? Is it exactly 30 days since the previous piece of data?, etc.). With this formula, you can check both.
Arguments: DAYS(date 2, date 1)
- Date 2 – The date you want to compare to date 1. Usually chronologically after Date 1, but not required.
- Date 1 – The date you want to compare to date 2.
Blog Posts using DAYS()
Videos using DAYS()