Working days in reverse

[wwyngaard]

I have a situation where I need to calculate backwards from a given date a certain number of work days. Like from 11/1/02 find the date that is 50 work days before that date as a start date. I am sure there is an elegant way to do it but just can't come up with it. I will also have to build in a holiday calculation to account for holidays but I should be able to build a case statement for it. I have found several solutions to find the number of work days between to dates but nothing to go back a set number of work days.

Thanks in advance.

Wayne

[djgogi]

Start with this one

pastdate=Status(CurrentDate)-Int(workDays/5)*7-Mode(workDays,5)

Dj

[wwyngaard]

I had to change the syntax from Mode to Mod and then your calculation worked perfectly. I assumed thats what it needed to be.

Thank you very much.