Date function

[william11]

My date (J4) is 1/15/2014

If billing frequency (H4) is 1, I want formula to add 1 year, every year to 1/15/2014
If billing frequency (H4) is 2, I want formula to add 6 months, every 6 months to 1/15/2014
If billing frequency (H4) is 4, I want formula to add 3 months, every 3 months to 1/15/2014

thank you.

 

[NeonRedSharpie]

I don't know where your formulas are going, but the easiest place would be to put it in J5-J(whatever). Then the formula is:

=DATE(YEAR(J4),MONTH(J4)+(12/$H$4),DAY(J4))

And you can drag it down.

 

[william11]

I don't know where your formulas are going, but the easiest place would be to put it in J5-J(whatever). Then the formula is:

=DATE(YEAR(J4),MONTH(J4)+(12/$H$4),DAY(J4))

And you can drag it down.

I am sorry I thought a previous formula I had received on this site was messed up but it turns out my dates were incorrect.

=IF(J4>TODAY(),EDATE(J4,12/H4),EDATE(J4,DATEDIF(J4,TODAY(),"m")+12/H4-(MOD(DATEDIF(J4,TODAY(),"m"),12/H4))))

Is what I was trying to do for the record.

 

[Scott Huish]

In J5:
=IF(COUNT($J$4:J4)<=$H$4,EDATE(J4,12/$H$4),"")

Copy down to J8.