Hi all,

Can networkdays function takes fixed holidays instead of having a list that covers every years' fix holidays. ie Christmas

=NETWORKDAYS(Date(01/01/2000),Date(12/31/2011),A1:A11)
Where A1 to A11 are December 25 of every year.

Is there better way than this?


Thank you very much.