How to account for weekends in date calculations?
Posted by Matthew Beckett on August 29, 2001 7:47 AM
I have a spreadsheet that tracks the date an item arrives and the date that our response is sent - the deadline for this is 20 working days. The current formula does the simple substraction but I can't get it to account for the weekends.
Is there a formula that would calculate this? There is a today() cell that I have tried to get it calculate from but without success - please help.