calculating number of days

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

Peo Sjoblom

Look at networkdays

=NETWORKDAYS(Start,End,Holidays)

where Holidays can be a range like H2:H12 with all the public holidays
 
C

Chip Pearson

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
 

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

VBA Coding Help for Beginner 0
Formula to tell day of week 3
Calculating days spent to complete a task 2
Calculate elapsed time excluding specific timeframe 10
calculate number of days formula 11
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Month days over a time period 5
How to calculate dates 6

Top