Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Formula for working days (exclude public holidays)
Hi Team,
I am using a formula (=WORKDAY(F10, 20)) to count 20 working days from 27 Nov 2023, however this is returning 25 Dec 2023.
Please can you advice how I can update this formula to exclude all the public holidays in Dec 2023?
Many Thanks
RE: Formula for working days (exclude public holidays)
Hi Kay,
Thank you for the forum question.
All date functions in Excel calculating working days (Workday, Networkdays, & Networkdays.intl) do not know which days are public holidays. You will unfortunately have to create a holiday list.
If you in a Excel worksheet type the dates for public holidays and let us just say in A1 to A10, then your formula should look like
=WORKDAY(F10, 20, A1:A10)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
