Increasing the Date by monthly using current formula

[rholdren]

Using Excel 265 Is there something I can add to this for B18 that would increase this by one month and B19 by 2 months and B 20 by 3 months etc.
=IF($B$17>0,Top_Portion_of_Aggregate!$D$2,"")

I have several templates and was just hoping to add to the current formula. I have looked all over and can't really seem to find a way to just add to the current formula.

Any help would be greatly appreciated.

Thanks

 

[alansidman]

DateAdd function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[rholdren]

DateAdd function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

I can't open the link I'm working from my work computer and it won't allow me access

 

[alansidman]

try this one

MS Excel: How to use the DATEADD Function (VBA)

This Excel tutorial explains how to use the Excel DATEADD function with syntax and examples. The Microsoft Excel DATEADD function returns a date after which a certain time/date interval has been added.

www.techonthenet.com

 

[rholdren]

I found it

 

[rholdren]

Consider this closed