MrExcel Publishing
Your One Stop for Excel Tips & Solutions

please help me!!! Stuck with working days...

Posted by Tina Janits on March 16, 2000 4:23 AM


My silly PC won't let me work out how to calculate work days in VBA. I need to subtract non-working time from normal days so that I am left with working days only. Is there hero who can help??


T xxx

Posted by JAF on March 16, 2000 4:53 AM

Try the NETWORKDAYS function

where holidays is an optional range of one or more dates to exclude from the working calendar.