Successively inputting Date on Merge Columns

[delvillardennis]

Hello All,


I have an excel file with merge cells as follows:


ABC DEF GHI

1 Jul-12 Sep-12 ?


In the merge column GHI, I want to input Oct-12 (i.e. format is mmm-yy)using a formula. This formula will be successively copied in the next merged columns. Please advice.

 

[SirJB7]

Hi, delvillardennis!

Assuming your cells are yet merged and that starting date is in A1 (A1:C1) cell, in D1 type and copy across as needed:

=FIN.MES(A1;0)+1 -----> in english: =EOMONTH(A1,0)+1

Regards!

 

[delvillardennis]

hello SirJB7,


The formula works. Many thanks...in Pilipino ---> Maraming Salamat!

 

[SirJB7]

Hi, delvillardennis!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!

PS: Malugod bumalik kailanman kailangan o nais... it's correct?

 

[delvillardennis]

nice and quite correct ---> Malugod bumalik kailanman kailangan o nais... it's correct?