>Thanks George,
>
>This is exactly what I'm looking for. I definitely got to get down to Georgia and pay up my Dark Beer tab! I was very close to debugging my version but yours is cleaner, less code and should execute faster. I may elect to remove holidays as well but is not critical - Thanks Marcia.
Anytime, Mike. I look forward to it.
As for the holidays, I'd certainly recommend using a table with absolute dates that was annually updated. Otherwise there'd be additional overhead of dealing with those instances where a holiday wasn't fixed (like Labor Day or Thanksgiving) or where the date fell on a Saturday or Sunday. The number of records required (a dozen or so maximum) is small so maintaining it shouldn't be a major problem.
George
Ubi caritas et amor, deus ibi est