i want add a date automatic 6 months before the date show.

Rane Yan

I Read through a number of posts, unable to find the right answer. I need some help to check if i want to purpurate the date as 6 months for the date below showing, how should i do the formula?

cheers,

Rane

Protonsponge

Hello @Rane Yan

I think the following formula will work out for you.

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

Protonsponge

Hello @Rane Yan

I think the following formula will work out for you.

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

Rane Yan

Hi Protonspounge,

this is working well! Thanks so much!

Best Regards,

Rane