Dates & Timestamps
today + 3 weeks | 1 October
yesterday - 8 weeks 3 days | 12 July
3 days from now | 13 September
3 days ago | 7 September
28 days before March 12 | 12 February
2 months 3 days after June 5 | 8 August
days since July 15 | 57 days
days till December 25 | 106 days
January 10 - February 5 | 3 weeks 5 days
3 March to 30 May | 2 months 3 weeks 6 days
days between 3 March and 30 May | 88 days
Monday - Friday | 4 days
Intervals of time are calculated from midday on the first date midday to midday on the last date in the interval. Use an inclusive interval function if you want to include both the starting and ending date in the interval (see below)
Monday through Friday | 5 days
April 1 through April 30 in days | 30 days
days in Q3 | 92 days
days in February 2020 | 29 days
midpoint between March 12 and April 5 | 24 March
halfway between today and next Thursday | 13 September
week of year | 36
week number on march 12, 2021 | 10
day of the week on January 24, 1984 | Tuesday
Unix time is a system for describing a moment in time, often used in programming. A timestamp is the number of seconds that have passed since the "reference date" (January 1st, 1970).
April 1, 2019 to timestamp | 1554109200
1559740303.48 to date | 5 June 2019 at 11:11 pm
To get a timestamp for the present moment, use current timestamp
current timestamp | 1559740303.48
April 1, 2019 3:30pm as iso8601 | 2019-04-01T15:30:00Z
Note: iso8601 formatted dates are not recognised in expressions.
They can be used for formatting answers, or via line references.
Last modified 1yr ago