Duration Formula

[Jonathon]

I am looking for a formula that works as a duration counter, (in
days), based on the start and end date. So for instance if I was
starting monday and finishing friday, and it was wednesday this
"Duration Formula" would tell me 3 days. Has anyone done something
like this?

Thanks in Advance,

Jonathon

 

[Andrew Lavinsky]

Would something like this work?

ProjDateDiff([Start],[Stop])

-A

 

[Jan De Messemaeker]

Hi,

I would say projdatediff([Start],[Current Date])
HTH

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

Would something like this work?

ProjDateDiff([Start],[Stop])

-A

I am looking for a formula that works as a duration counter, (in
days), based on the start and end date. So for instance if I was
starting monday and finishing friday, and it was wednesday this
"Duration Formula" would tell me 3 days. Has anyone done something
like this?

Thanks in Advance,

Jonathon

 

[Jonathon]

Hi,

I would say projdatediff([Start],[Current Date])
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 Lavinsky" <(Catapult Systems)> wrote in message

Would something like this work?

ProjDateDiff([Start],[Stop])

-A

I am looking for a formula that works as a duration counter, (in
days), based on the start and end date. So for instance if I was
starting monday and finishing friday, and it was wednesday this
"Duration Formula" would tell me 3 days. Has anyone done something
like this?
Thanks in Advance,
Jonathon- Hide quoted text -

- Show quoted text -

Thanks for the help. This one has really stumped me. Would I put that
into a Number Field? Text Field? The formula keeps giving me a number
in the 1000's even if the end date is passed, BTW, I want to use this
at a task level. Thanks again.

 

[Andrew Lavinsky]

Use it as a Duration field, and it should be fine.

I'd also point out that instead of either the Stop or Current Date fields,
you could also use the Status Date field.

They're all valid depending on what you're trying to get out of the equation
and your project update methodology.

-A

Hi,

I would say projdatediff([Start],[Current Date])
HTH
--

Jan De Messemaeker

Microsoft Project Most Valuable Professional

+32 495 300 620

For availability check:http://users.online.be/prom-ade/Calendar.pdf

Would something like this work?

ProjDateDiff([Start],[Stop])

-A

I am looking for a formula that works as a duration counter, (in
days), based on the start and end date. So for instance if I was
starting monday and finishing friday, and it was wednesday this
"Duration Formula" would tell me 3 days. Has anyone done something
like this?

Thanks in Advance,

Jonathon- Hide quoted text -

- Show quoted text -

Thanks for the help. This one has really stumped me. Would I put that
into a Number Field? Text Field? The formula keeps giving me a number
in the 1000's even if the end date is passed, BTW, I want to use this
at a task level. Thanks again.

 

[Jonathon]

Again, I really appreciate the help!! The code worked like a charm in
a duration field. Life savers...

Jonathon