98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Changing non workdays
Changing non workdays
Resolved · High Priority · Version 2003
Kirsteen has attended:
Excel Intermediate course
Changing non workdays
We want to calculate work days, but need to base our calculations on a non-standard working week, ie, the standard working week contains two weekend days where as we need it to contain only one weekend day (a Friday) for our purposes.
RE: Changing non workdays
Hi Kirsten
Thank you for your question.
To calculate dates excluding fridays you need to combine two functions. The first is very simple Weekday which will return the numeric value of which day of the week it is. Ie if A1 contained 23/10/2008 then Weekday(A1) would return a 5.
The second function is IF and we will use the following logic to calculate the next working day:
If the first date is a thursday add 2 days (to skip friday), otherwise only add one.
So the formula to calculate the next working day from a date in A1 would be:
=IF(WEEKDAY(A10)=5, A1+2, A1+1)
Let us know if that helps.
Laura GB
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |