Add A Month, or two

[Scott C]

I am tracking several thousand project tasks by date. Occassionally I need
to slide several tasks by 2-3 months. Is there a formula that will increment
just the month section of a date field? The field id formatted mmm/dd/yyyy.

 

[Ken Snell [MVP]]

Check out the DateAdd function. It will return a date that differs from the
starting date by the increment and unit that you specify in the function's
arguments.