custom field - formula

[sophie]

Hello,

I have following formula to calculate the working days
between date 1 & 2 :
ProjDateDiff([Date1],[Date2])/(8*60))

My problem is when I'm not entering any dates in
column "date 1" & "date 2" the result is an "#ERROR"
message in the column which calculates the working days.

Can you please help me to complete the formula, so I'm not
receiving this message anymore.

I thank you in advance.

Sophie

 

[Gérard DUCOURET]

Hello Sophie
Try the "If" test :

IIf([Date1]<100000 And [Date2]<100000,projDateDiff([Date1],[Date2])/(8*60),0)

Hope this help,

Gérard Ducouret

 

[sophie]

It worked, thanks very much!

-----Original Message-----
Hello Sophie
Try the "If" test :

IIf([Date1]<100000 And [Date2]<100000,projDateDiff ([Date1],[Date2])/(8*60),0)

Hope this help,

Gérard Ducouret

"sophie" <[email protected]> a écrit dans le message de [email protected]...

Hello,

I have following formula to calculate the working days
between date 1 & 2 :
ProjDateDiff([Date1],[Date2])/(8*60))

My problem is when I'm not entering any dates in
column "date 1" & "date 2" the result is an "#ERROR"
message in the column which calculates the working days.

Can you please help me to complete the formula, so I'm not
receiving this message anymore.

I thank you in advance.

Sophie

.