changing non workdays

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Changing non workdays

Changing non workdays

resolvedResolved · 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.

Edited on Fri 24 Oct 2008, 10:36

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips


Server loaded in 0.08 secs.