98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Work days
Work days
Resolved · Low Priority · Version 2007
Wed 15 Oct 2008, 11:37Delegate Michael said...
Michael has attended:
Excel Advanced course
Work days
e.g. I want to add 7 working days to a start date and then carry this formula down several days so that only working days (monday to fri and excl public holidays are considered)
Thu 16 Oct 2008, 13:23Trainer Rajeev said...
RE: work days function
Dear Michael
Thank you for attending the Excel Advanced course. I hope you enjoyed the course and benefited from it.
You would need to use the WORKDAY Function to do this!!
Please find attached Excel file where I have done some calculations for you. I searched on the internet and found all the Public holidays scheduled for 2009.
As you can see on the peach coloured cells I have entered some dates and in eth light green cells the result appears. The function I used on cell B2 is =WORKDAY(A2,6,$G$3:$G$10)
Where
START DATE: A2 is the date that I am inputting.
DAYS: 6 is the no. of working days I want the difference. I used 6 so that I the date I entered would be included.
HOLIDAYS: $G$3:$G$10 in the range where I have entered all the public holidays.
I believe it is self explanatory and hope this helps If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Attached files...
calculating working days excluding public holidays.xls
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
