Next date of aniversary 3m 6m 9m 1 year

[Vinhas]

hi everyone,

I need help to put a formula that give me the next date of aniversary corresponding at 3 months, 6 months, 9 months and 1 year (L - M - N - O / 8) of the date in column "I" and the actual date ("O" - 4).

for example if I have the date in column "I" 01-01-2020 and the date of today ("O" - 4) , the date of (next) 3 months it will be 1 October 2020, for 6 months it will be 31 December 2020, for 9 mounts it will be also 1 october and for year it will be 01-01--2021.

Thanks in advance

[bebo021999]

in L8:

Please Login or Register  to view this content.

Drag down and accross

[kvsrinivasamurthy]

Post deleted

[José Augusto]

Hi

I suppose you want this

In L8 use the following formula and drag down

Please Login or Register  to view this content.

In M8 use the following formula and drag down and across

Please Login or Register  to view this content.

See the file

[Vinhas]

thanks, but I need the formula give me the dates I have in line "20" (for the example of date in line "8")and your formula don't give the same dates ???

[Vinhas]

=DATAM($I8;ARRED;CORRESP(DATADIF($I8;$O$4;"M")+1,3)) ----- I can't understand what I doing not well !!! can you help please ??

[José Augusto]

Hi Vinhas

I don't understand where the formula you write in post 6 comes from.

My formula in L8 is

Please Login or Register  to view this content.

or similarly, in PT,

Please Login or Register  to view this content.

Have you seen the file?

[Vinhas]

Sorry it was a mistake (post 6) !!
Thanks for your help. This formula solved for column "L". What I have to modify in the formula to reply in column "M" "N" and "O" ???

[José Augusto]

Hi Vinhas

The file contains the formulas you want.

For column M, N, O the formula is, (in PT)

Please Login or Register  to view this content.

Or In (EN)

Please Login or Register  to view this content.