Help with "Date Formulas" that detail NETWORKDAYS & Statutory UK Holidays

**Moggzy** · 09-04-2012, 06:02 AM

I've attached a spreadsheet I am using to track the procurement process of key packages for the industry I work in. The spread sheet works by inserting a date when I need the package on site. (Start on site cell AF5)
While its a good working spreadsheet it is not entirely accurate as it works on a 7 day week, 365 days per year. I need a formula that will work utilising networks days (or a 5 day working week - Monday to Friday) that also takes cognisance of statutory holidays (Bank holidays, Christmas etc)
Any help would be welcome.

**sathyaganapathi** · 09-04-2012, 06:19 AM

Hello, you can use =networkdays.intl for this purpose
regards, sathyaganapathi

**Moggzy** · 09-04-2012, 06:54 AM

sathyaganapathi, thanks for the suggestion, but it doesn't work.

it's returnig the error message #NAME?

Moggzy

**daddylonglegs** · 09-04-2012, 06:57 AM

NETWORKDAYS.INTL is only available in Excel 2010, presumably you aren't using that version, hence #NAME? error

If you only need to exclude holidays and weekends the basic NETWORKDAYS function should work for you, post back if you need help with it

**Moggzy** · 09-04-2012, 07:05 AM

I'm using Excel 2007 (Company Standard).

I've put the "NETWORKDAYS" formula in cell AD5 as; =NETWORKDAYS,AF5-(AE5*7)

???

**daddylonglegs** · 09-04-2012, 07:12 AM

OK, so you want a date returned? That requires WORKDAY function, sorry

Try

=WORKDAY(AF5,AE5*5*-1)

If AE5 contains 10 that will give you a date 50 working days (10 work weeks) before AF5, is that right?

If you want to exclude holidays then list your holidays somewhere on the sheet, name that range holidays and use this version

=WORKDAY(AF5,AE5*5*-1,holidays)