Difference between two dates excluding Weekends and Holidays

[Vuke]

Hello all,

FYI...I'm new to Crystal!

I am facing the problem now of finding the number of days between two dates (ie..closing dates) and excluding the weekends and holidays. My problem is however is a little more complex then that. There is a start date ({Table.StartDate}) and a close date (Table.CloseDate}) for each account and I have to find how many days (minus wk ends and holidays) between the open and close dates. It is only for a three month period (Oct 2002 thru Dec 2002). Of course the only two holidays I need pulled are Christmas and Thanksgiving. I just need a little help to get the ball rolling.

Thank you

vuke

 

[rosemaryl]

Dear Vuke,

See Ken Hamady's faq: forum149

He has formulas to this and I have used and modified for my use and find them to work fine.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Vuke]

Thank you...I just got off his site and found those formulas.

Thanks again,

vuke