Automatic Rolling Months

[Oli2509]

Hello Guys,

I am actually having an issue where i am using dependant drop down with excel and i want to add to my existing formula data for 24 and 36 months planning, can someone help me please as my actual formula is as per below:

=INDEX(ListeMois,MOD($AB$29+COLUMNS($E$54:E54),12)+1) in fact i want to add ref ListeMois24 and ListeMois36


Your help and advice will be most welcome.

Thanks.

 

[James006]

Hello,

To add n months to a given date ... you can use

=Edate(yourdate, n )

Hope this will help