Share this article:

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.