Days Left

  • Thread starter Thread starter Gala
  • Start date Start date
G

Gala

Can you help with a formula for working days left minus
holidays before 12/31/2003? Trying to use NETWORKDAYS
function but it doesn't seem to work with TODAY(). Thanks.
 
=NETWORKDAYS(TODAY(),"12/31/2003"+0,Holidays)

where Holidays stands for a range housing holiday dates.
 
This works for me:

=NETWORKDAYS(TODAY(),"12/31/2003",holidays)

where "holidays" is a named range of holidays.
 
Back
Top