Sadly, this is no simple task. Here's why. Each business I've encountered has its own calendar and you can't use some assumption that workdays are M-F. As such, I have to create a database of the work calendar, a program for the business to create such and then more code to cound the days up.
Figure about a week to create such, 3 more weeks if documentation is required.
I am running Windows 2000 and Excel 2000. My problem is creating a formula that will calculate Days Lost from a First Date of Absence and the Return to Work Date. I need to be able to calculate the Days Lost excluding Saturday and Sunday. Here is what my spreadsheet looks like:
Date of Absence
Return to Work
Can someone please help me out with the Formula in Days Lost column?
Thank you so much!