Adding number of months from date

[bouncingbudha]

Hi

How do you add a number of months on a date

E.g =Now() + 7 (months)

Ive tried a few things but cannot crack it
Any help appriecated

[FDibbins]

TRy EDATE(A1,7)

If will be repeating/copying this through a number of cells, put TODAY() in 1 cell and reference it. TODAY() is a volatile function - recalcs with any worksheet change, and could slow things down if you have a lot of them

[bouncingbudha]

Brilliant Thanks

[FDibbins]

Happy to help and thanks for the feedback