EXTRACTDATES()

Extract list of dates within textual value

Returns list of Date values within a textual value.

Sample usage

EXTRACTDATES("Set a meeting for November 14th at 4pm.") returns a list of one item: the date of November 14 of the current year.

EXTRACTDATES("Set a meeting for tomorrow.") returns a list with one item: tomorrow's date.

EXTRACTDATES("Yesterday, today, and tomorrow.") returns a list with thee items: the dates equivalent to (TODAY() - 1), TODAY(), and (TODAY() + 1).

EXTRACTDATES("1 month 3 days ago; 7 years 2 months 4 days ago; 2 weeks from tomorrow; in 4 days") returns a list with the corresponding relative dates.

EXTRACTDATES("first of last month; first of this month; first of next month; 15th of this month; first day of next year") returns a list with the corresponding relative dates.

EXTRACTDATES("Monday; last Monday; this Monday; next Monday; Monday 2 weeks from now") returns a list with the corresponding relative dates.

EXTRACTDATES("March") returns a list with two dates, the first day of the given month of the current year and the first day of the following month: 3/1/2021, 4/1/2021.

EXTRACTDATES("2020") returns a list with two dates, the first day of the given year and the first day of the following year: 1/1/2020, 1/1/2021. Any four-digit value between 1900 and 2050 (inclusive) are handled as such.

Syntax

EXTRACTDATES(text-to-extract-from)

  • text-to-extract-from - Any textual value. May include specific dates, dates written in prose, relative dates (such as tomorrow or yesterday), day and month names, and bare 4-digit year numbers. See samples above.

See also

Date and time expressions

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATETIMES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false