Days Left

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.
 
A

Aladin Akyurek

=NETWORKDAYS(TODAY(),"12/31/2003"+0,Holidays)

where Holidays stands for a range housing holiday dates.
 
J

J.E. McGimpsey

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

Countdown macro - display settings 2
How to implement two shifts per day with multiple teams 0
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
problem with time subtraction 7
Work Budget Salary vs Real Time Salary 0
Networkdays two years 4
Calculate days help 2
returning a date 7 business day excluding holidays in the future 2

Top