Suppose you want to calculate a date that is 91 days from the current date. You can use the following formula:

\[=EOMONTH(TODAY(), 1)\]

\[=EOMONTH(TODAY(), 3)\]

This function is useful for calculating intervals between the current date and a specific date.

\[=DATE(year, month, day)\]

\[=DATE(2022, 1, 1)\]

returns the last day of the month, one month from the current date.

\[=TODAY()\]