Also, very cool, but again - what about holidays? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, February 18, 2005 10:13 PM Subject: [RBG7-L] - RE: "Working days" logic
> > Sorry for the delay in posting my reply. It has been a busy week. > > I also said I was going to work on this, but kind of dropped the ball. Here's > what I got tonight -- not thoroughly tested, but I'm pretty sure it's on the > right track (where vDate1 and vDate2 hold the start and end dates): > > SET VAR vBusinessDays = + > (6-IDWK(.vDate1)) + IDWK(.vDate2) + ((INT((.vDate2-.vDate1)/7)) * 5) > > -- > Larry > >
