DateADD function in Excel


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

Called thus:
or with a cell ref:

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