I have quite a few formulae using WORKDAY & NETWORKDAYS which necessitates a long list of holidays in the required format. To save updating all these formulae with new future holiday dates I thought a constant would be ideal, so I created c_HOLS.
Although the formulae work perfectly when the holidays are included directly, they fail to work when I try to bring them in using c_HOLS. I’ve tried different formats including the [ ] in C_HOLS and excluding them and putting directly in the formula but nothing seems to work.
Any ideas on formula syntax to bring the constant in? Thanks, Ian