Add A Month, or two

S

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.
 
K

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.
 
Top