These docs are for v1.0. Click to read the latest docs for v1.2.

WEEKSAGO

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

Syntax

=WEEKSAGO(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

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

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

=WEEKSAGO("2020-01-01")0.25595238095238093
Gets the number of weeks from midnight January 1, 2020 to January 2, 2020 at 12:00pm

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