DAYSAGO

Gets the number of days between the specified date and now.

Syntax

=DAYSAGO(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

The following examples assume the current date is January 2, 2020 at 12:00pm

=DAYSAGO("2019-01-01")366.7916666666667
Gets the number of days from midnight January 1, 2019 to January 2, 2020 at 12:00pm

=DAYSAGO("2020-01-01")1.7916666666666667
Gets the number of days from midnight January 1, 2020 to January 2, 2020 at 12:00pm

=DAYSAGO("2020-01-03")-0.20833333333333334
Gets the number of days from midnight January 3, 2020 to January 2, 2020 at 12:00pm