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
