Workday Function

O

olivia824

I am new and not good at excel. I need to find the number of day
between two dates without weekends? I have read posts and don'
understand the networkdays stuff and if I did, I wouldn't know how t
set it up. If anyone could help with the formula, I would reall
appreciate it.
Thank you
Heathe
 
G

Govind

Hi,

Try usingn Networkdays function.The syntax is

= NETWORKDAYS(start_date,end_date,holidays)

Holidays is an optional range of one or more dates to exclude from the
working calendar, such as state and federal holidays and floating holidays

However make sure you have the Analysis Toolpak installed before using
this function.

Regards

Govind.
 
O

olivia824

Thank you, Thank you, Thank you, Management is going to be impresse
that I found the correct on time delivery for them
 
O

olivia824

I did =networkdays(a1,b1). Now I have a problem with when the dates ar
the same it says it is one day over, and it should be zero? An
suggestions
 
C

Chip Pearson

Subtract 1 from the result of NETWORKDAYS. E.g.,

=NETWORKDAYS(A1,B1)-1


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

Arvi Laanemets

Hi

When start or end date are weekend days, this formula returns wrong result.

Instead, or use start and end days which are included into time interval, or
substract 1 from end day (NB! be sure that no end day equals to start day
then)
=NETWORKDAYS(A1,B1-1)


Arvi Laanemets


Chip Pearson said:
Subtract 1 from the result of NETWORKDAYS. E.g.,

=NETWORKDAYS(A1,B1)-1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
M

Myrna Larson

Note that the formula you say works could have been found in Help. There are
several examples.
 
Top