Examples

EXTRACTDATES("Set a meeting for November 14th at 4pm.") : a List of Date values with one item, the date of November 14 of the current year (equal to DATE("11/14/" & YEAR(TODAY()))).

EXTRACTDATES("Set a meeting for tomorrow.")  : a List of Date values with one item, the date for tomorrow (equal to (TODAY() + 1)).

EXTRACTDATES("Yesterday, today, and tomorrow.") : a List of Date values 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") : a List of Date values 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") : a List of Date values with the corresponding relative dates.

EXTRACTDATES("Monday; last Monday; this Monday; next Monday; Monday 2 weeks from now") : a List of Date values with the corresponding relative dates.

Syntax

EXTRACTDATES( text-to-extract-from )

Arguments

text-to-extract-from (any textual value) : May include specific dates, dates written in prose, and relative dates, such as “tomorrow” or “yesterday”. See examples.

Return Value

A List of Date values. 

See Also

EXTRACT(), EXTRACTCHOICE(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()

Did this answer your question?