DateADD function in Excel


=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))

This could get untidy so how about your own function?:

Called thus:
=mydateadd(“m”,1,TODAY())
=mydateadd(“m”,-1,”31/3/2009″)
=mydateadd(“m”,1,”31/3/2009″)
or with a cell ref:
=mydateadd(“m”,1,D23)

supported of course by the udf in code:

Function myDateAdd(interval, howmany, adate)
myDateAdd = DateAdd(interval, howmany, adate)
End Function

If you only need to add months, this is a workable solution:
=EDate(“3/31/2009”, +/- # of months) Eg. EDate(“1-1-2014”,+3) = 1-4-2014