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.