Results 1 to 4 of 4

Thread: How to calculate duration in days

  1. #1
    Join Date
    Aug 2006
    Posts
    114

    How to calculate duration in days

    I have recently created 2 new custom fields, that is, a date field (date1) and duration (duration1). I just want to calculate the difference in days between 'start' and dat1 in day. When I am trying to create a formula for duration1 of: start - date1 then I am getting an odd answer. Is there anyone who can give me some kind of a formula to calculate duration between 2 dates? Thanks.

  2. #2
    Join Date
    Oct 2005
    Posts
    1,224

    Re: How to calculate duration in days

    Incase you want the difference in calendar days, then you can simply use the DateDiff function and if you want the difference in Working Days, then you can use ProjDateDiff function. Hope this helps.

  3. #3
    Join Date
    Aug 2006
    Posts
    114

    Re: How to calculate duration in days

    Thank you, I tried to use the ProjDateDiff function but if I have got a different calendar than the project calendar then how can I make the distinction in the formula?

  4. #4
    Join Date
    Oct 2005
    Posts
    1,224
    You just need to put the name of the calendar between double quotes, like for example:
    ProjDateDiff([Start],[Finish],"Six Days")

    Hope this helps.

Similar Threads

  1. How to calculate pay period between interval of 15 days
    By Bala!aditya in forum MS Office Support
    Replies: 2
    Last Post: 28-01-2012, 02:43 PM
  2. Automatically change duration from days to weeks
    By mbbackus in forum Microsoft Project
    Replies: 5
    Last Post: 02-11-2011, 02:40 AM
  3. Calculate Working days in MySql
    By DeMario in forum Software Development
    Replies: 4
    Last Post: 06-11-2009, 05:00 PM
  4. Duration shown in days(need) to display hours
    By The Man in forum Microsoft Project
    Replies: 0
    Last Post: 23-09-2008, 05:26 PM
  5. duration calculation doesn't skip non-working days
    By Donald in forum Microsoft Project
    Replies: 3
    Last Post: 24-01-2008, 04:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •