=workday formula returning #ref

[tinane35]

Hi, hoping someone can help as I'm extremely puzzled with this one.

I used a workday formula to bring back an 'ETA' date according to 'lead time' days. the formula looks like this:

=WORKDAY(AN6,AR6,(holidays))

AN6 = shipped date (start date)
AR6 = lead time (days)

the formula is supposed to show a calculated 'ETA' excluding weekends hence the '(holidays)' rule within the formula.
This WAS working when i first input the formula and was correctly bringing back a work day date. However, this is a shared excel sheet and for some reason now the formula is bringing back '#REF'. I've looked into the 'help' suggestions provided by excel but it is only suggesting that the error has arose due to formula possibly referring to an invalid column (a column that has possibly been moved or deleted) or the date format is incorrect. I have checked both of these and this is not the case. the columns the formula is referring to are still there and are still correct.

AR6 (number of days) is in 'general' format - i've tried changing this to 'number' and it still doesn't work.
AN6 (start date) is in 'date' format - dd/mm/yyy (as is my computer system)
and the cell I have this workday formula in, is also set to 'date' format as above.

I cannot understand why all of a sudden it is not working. (picture attached)

Any suggestions welcome!
thanks in advance.

 

[Fluff]

Check that nobody has deleted (or renamed) the holidays range

 

[tinane35]

Check that nobody has deleted (or renamed) the holidays range

thanks Fluff however there was no 'holidays' range ever entered. When looking up the formula it suggested 'holidays' would exclude all weekends automatically, which is what it was doing originally. The formula hasn't changed from when it was working originally.

 

[Fluff]

Holidays needs to be a named range with a list of holidays, it has nothing to do with excluding weekends, the formula does that automatically.

 

[tinane35]

Holidays needs to be a named range with a list of holidays, it has nothing to do with excluding weekends, the formula does that automatically.

ah thank you. i have taken out 'holidays' and this has worked. Still don't understand how it was working to begin with as the formula hadnt been amended in anyway, however happy it is working now. thanks

 

[Fluff]

Glad it's sorted & thanks for the feedback.