×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Month Duration - Date

Month Duration - Date

Month Duration - Date

(OP)
I have a project that contains a 4 month task.  The task is a regulation requirement, where a study must be conducted for 4 months, regardless of the # of days within a month.  

So, if the task starts on 1/20, it must end on 5/20.  If it starts on 2/13, it must end on 6/13.

The problem is that if I just use "4 months" as the duration in MS Project, the finish date is calculated at 80 working days after the start.  So, a start date of 3/11 produces a finish date of 6/30.  The actual finish date should be 7/11, and the task appears to finish almost 2 weeks before it actually will.  

I can put in "89 days", and that will give me the correct finish date, but that will only work if the task falls in these months.  If the preceeding tasks are delayed or finish early, the 4 month task may start in different months, and "89 days" won't work.

So, is there a way to make Project calculate a finish date by just adding 4 to the month of the start date?  That way, I won't always have to check this task to make sure it's scheduled correctly as other tasks finish.  

I have created a custom field as "Date1" that will calculate the date I need:

CODE

dateadd("m",3,[Start]
But, I can't figure out how to make the finish date align with this.  Maybe I'm off on the wrong path. Any help would be appreciated.  Thanks!

RE: Month Duration - Date

(OP)
Sorry, I had a typo in the formula, code should read:

CODE

dateadd("m",4,[Start])
 

RE: Month Duration - Date

The easiest way to handle this situation is using elapsed time.  It turns the time into physical number of days.  To do this just put an "E" in front of the months.  For example 4m should be entered as 4em. in the duration column.  You should now see the number of days you are trying to achieve.

Good luck

E. Lehnert, PMP, MCT
www.lehnertcs.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources