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

Hi,

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??

Thanks!

T xxx


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


Try the NETWORKDAYS function

=NETWORKDAYS(start_date,end_date,holidays)
where holidays is an optional range of one or more dates to exclude from the working calendar.


JAF