Calculated field

Hi Assaf

In Lotus 123 there is a formula that counts the number of work days between two calendar dates @networkdays(date 1, date 2,Holiday-range,"weekend")

You need a range of dates that represent the holidays between date 1 & 2 and the numbers "56" to represent UK Sat & Sun weekends.

Israel mey have different day numbers.

There is a similar formula in excell but I don’t think it works so elegantly as Lotus.

Best Regards

Mike Testro

Hi Assaf,

You just need to change your formula a bit:
ProjDateDiff(Date(),[Finish],"Standard")/480

That will do the trick if the working days are to be calculated with respect to your standard calendar (with weekends, holidays, etc. defined) and based on a 8 hour working day. The division by 480 (60min/hr x 8hrs/day)is to get the result from minutes to days. If working e.g. 9 hrs a day the number should be 540 (9x60).

Regards,

Bo