WEEKSAGO
Gets the number of weeks between the specified date and now.
Syntax
=WEEKSAGO(date)
Arguments
| Argument | Type | Description |
|---|---|---|
| date | Date | The 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
Updated 9 months ago