Date formulas - Months

allison110246

Hi - I'm trying to add 6 months to the day to a date referenced in another field.  It is basically a date of execution and plus 6 months a review date.  How is this possible?  Adding the number of days gets me close, but not exact.

Thanks!

Paul Newcome

Try something like the below. We first use a DATE function to simply add 6 to the month. Then we use an IFERROR function to produce a different date if the month + 6 is more than 12. The different date would simply be subtracting 6 months and then adding 1 to the year.

 

=IFERROR(DATE(YEAR([Execution Date]@row), MONTH([Execution Date]@row) + 6, DAY([Execution Date]@row)), DATE(YEAR([Execution Date]@row) + 1, MONTH([Execution Date]@row) - 6, DAY([Execution Date]@row)))