Add A Month, or two

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract the Month from a cell with a formatted date 3
Group by month 2
Importing Date fields from Excel 2
date format convert 2
Excel Help with dates 2
counting records by month and year / date format issues 1
Month (MMM) from date (dd/mmm/yy) 1
graph by month/year a count of a list of dates 1

Back
Top