How to calculate duration in days

[sdc]

I have created 2 new custom fields - a date field (date1) and duration
(duration1). I would like to calculate the difference in days between
'start' and date1 in days. If I try to create a formula for duration1 of:
start -date1 I get an odd answer. Can you please help me with the formula to
calculate duration between 2 dates.

Thank you!

 

[Jan De Messemaeker]

Hi,

If you want the difference in calendar days, use the DateDiff function
If you want the difference in Working days, use ProjDateDiff function.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Andrew]

Jan

I tried the ProjDateDiff function, if I have a different calendar than the
project calendar how do I make the distinction in the formula ?

Regards

Andrew

 

[Jan De Messemaeker]

Hi,

Put the name of the calendar between double quotes, for instance:

ProjDateDiff([Start],[Finish],"Six Days")

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Andrew]

Magic

Thankyou very much

Regards

Andrew

Hi,

Put the name of the calendar between double quotes, for instance:

ProjDateDiff([Start],[Finish],"Six Days")

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Jan

I tried the ProjDateDiff function, if I have a different calendar than the
project calendar how do I make the distinction in the formula ?

Regards

Andrew