Calculate Week-Days (Monday to Friday) 1

[DerbyNeal]

Hi,

I'm using Crystal 10 and need to create a formula that outputs a date (dd/mm/yyyy). I have a start date and a numeric field which represents the Date increment.

What I need to do is output the result of Start Date + Numeric - but incrementing using a count of 'Working Days' (Monday to Friday).

For example:
If Start Date = 06/09/2007 (dd/mm/yyyy - Thursday) and
Numeric Count = 7
Then the Output should be 17/09/2007 (dd/mm/yyyy - Monday).

Because the count is on the succesive Friday; Monday; Tuesday, Wednesday; Thursday; Friday and Monday), thereby ignoring the 2 weekends during this period.

Any ideas?

Thanks in advance,

 

[IanWaterman]

Neal

Check out this link from Ken Hamady,I have used it and it works brilliantly.

http://kenhamady.com/form01.shtml

Ian

 

[DerbyNeal]

Excellent... Many, many thanks.