calculating number of days

  • Thread starter Thread starter Humbertt
  • Start date Start date
H

Humbertt

I have two columns, A1 (variable start date) and B1 (fixed
end date), I would like to calcuate the number of
(busniess) days between A1 & B1 excluding weekends or x
number of days? If there a forumla or an appoach i can
take. Thank you.
 
Look at networkdays

=NETWORKDAYS(Start,End,Holidays)

where Holidays can be a range like H2:H12 with all the public holidays
 
Take a look at the NETWORKDAYS function. This will compute the number of
days between two dates, excluding weekends and, optionally, holidays. This
is part of the Analysis Tool Pack add-in, so you must have this installed in
order to use the function.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top