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