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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Networkdays two years 4
Adding days by using NETWORKDAYS 2007 formula 0
NETWORKDAYS HELP 0
Working days left in a month. 4
Calculate days help 2
Can't get NETWORKDAYS to calc elapsed banking days in a month 2
#NAME? Error 3
returning a date 7 business day excluding holidays in the future 2

Back
Top