calculate number of business days between the 2 dates

G

Guest

Hi Experts,
I have a query, I want to calculate number of days between 2 given
dates...to be more clear i want excel to calculate only business days
monday-friday and not saturdays and sundays. Please help me...
 
T

Tom Ogilvy

If you have the analysis toolpak installed in Excel, then you can use the
NetWorkdays function. See Excel help for details.
 
O

Oorang

LOL, yah I built that function from scratch only to find out that it was
already built in when I went to show off my new toy to a coworker. They were
like "Uh, dude, I hate to rain on your parade but that already exists."
 

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

Calculate Payment Days and Date 3
Normal Days to business days 5
Subtracting AD and/or BC dates 21
Calculate the number of days between two dates 23
Calc Number of Months PER YEAR Between Dates 2
Excel Calendar/Rota program problem 2
calculate number of days formula 11
Calculating dates to include Saturdays but not Sundays 1

Top