Formula for working days to or from

[bam]

Hello, I'd like to get some help with a formula.
I defined a custom field with this formula --- [Baseline1 Finish]-Now()
Presently, the fields display values like 20.88.
I want to show the working days until (or past) certain dates -- not the
calendar days.
And I'd like to display whole numbers (28) with no decimals (.88)

Thanks for any help you can provide.

bartmac

 

[Jan De Messemaeker]

Hi,

The function to use is ProjDateDiff rather than directly subtract two dates.
HTH

 

[bam]

Thanks, another question .. the new formula I created is ...

ProjDateDiff(Now(),[Baseline1 Finish])/480

For tasks due today (5/31) I show values of .96. I'd like to show a value of
"0"

For tasks due on Thursday (6/2), I shokw values of 2.95. I'd like to show
values of "2."

Any way to do that?

Thanks again,

bartmacl



ProjDateDiff([Baseline1 Finish],Now())

Hi,

The function to use is ProjDateDiff rather than directly subtract two
dates.
HTH

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

Hello, I'd like to get some help with a formula.
I defined a custom field with this formula --- [Baseline1 Finish]-Now()
Presently, the fields display values like 20.88.
I want to show the working days until (or past) certain dates -- not the
calendar days.
And I'd like to display whole numbers (28) with no decimals (.88)

Thanks for any help you can provide.

bartmac

 

[JackD]

Yes. Use integer division and divide by 1.
To do integer division instead of regular division you use the backslash "\"
This is how your formula would look:

(ProjDateDiff(Now(),[Baseline1 Finish])/480)\1

It divides by 1 and discards the remainder.
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

Thanks, another question .. the new formula I created is ...

ProjDateDiff(Now(),[Baseline1 Finish])/480

For tasks due today (5/31) I show values of .96. I'd like to show a value of
"0"

For tasks due on Thursday (6/2), I shokw values of 2.95. I'd like to show
values of "2."

Any way to do that?

Thanks again,

bartmacl



ProjDateDiff([Baseline1 Finish],Now())

Hi,

The function to use is ProjDateDiff rather than directly subtract two
dates.
HTH

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

Hello, I'd like to get some help with a formula.
I defined a custom field with this formula --- [Baseline1 Finish]-Now()
Presently, the fields display values like 20.88.
I want to show the working days until (or past) certain dates -- not the
calendar days.
And I'd like to display whole numbers (28) with no decimals (.88)

Thanks for any help you can provide.

bartmac

 

[bam]

Wow, nice. Thanks!

bartmacl

Yes. Use integer division and divide by 1.
To do integer division instead of regular division you use the backslash
"\"
This is how your formula would look:

(ProjDateDiff(Now(),[Baseline1 Finish])/480)\1

It divides by 1 and discards the remainder.
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
.

Thanks, another question .. the new formula I created is ...

ProjDateDiff(Now(),[Baseline1 Finish])/480

For tasks due today (5/31) I show values of .96. I'd like to show a value of
"0"

For tasks due on Thursday (6/2), I shokw values of 2.95. I'd like to show
values of "2."

Any way to do that?

Thanks again,

bartmacl



ProjDateDiff([Baseline1 Finish],Now())

"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in
message

Hi,

The function to use is ProjDateDiff rather than directly subtract two
dates.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"bam" <[email protected]> schreef in bericht
Hello, I'd like to get some help with a formula.
I defined a custom field with this formula --- [Baseline1 Finish]-Now()
Presently, the fields display values like 20.88.
I want to show the working days until (or past) certain dates -- not the
calendar days.
And I'd like to display whole numbers (28) with no decimals (.88)

Thanks for any help you can provide.

bartmac