Calculate Business Days

Last Post 26 Oct 2010 02:50 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
werice
New Member
New Member

--
25 Oct 2010 04:33 AM
My co-worker asked this question.  If anyone can answer it please do so!!!

Hi Guys, What do you all know about calculating the number of business days between two dates? Jessica needs the 10 day window for submittal of site visits to be changed to 10 business days. Outside of discounting Saturdays and Sundays I’m not sure how to account for all holidays (for every year) especially ones like Easter where they are different year to year. I asked Jessica to send me a definitive list of days that shouldn’t be counted as business days – besides Saturday and Sunday of course – but even if I have those dates – how do I code for future years? I have been googling the problem – but haven’t found any really good solutions.

Thanks!!!
Bill
gunneyk
New Member
New Member

--
26 Oct 2010 02:50 PM
Do a search for calendar tables. There are plenty of examples of how they will suite this need.
You are not authorized to post a reply.

Acceptable Use Policy