Get 6 Months prior Date

You can have scenarios where you would need to find out a date which is 6 months prior to today’s date.

In such cases, you can make use of the EDATE function which returns the serial number of the date that is the indicated number of months before or after the start date

Syntax

EDATE(start_date, no_ofmonths)

Formula

DATESTR(UNIXTIME(EDATE(TODAY(), -6)),“MM/DD/YYYY”)

where

  • the UNIXTIME function to convert the date to Unix time

  • the DATESTR to display the date in the format specified