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)
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
calculating working days excluding public holidays.xls
