Workday Function

[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

 

[NH]

Say start date is on cell A! end date on cell B1
on cell C1 type =NETWORKDAYS(A1,B1)

 

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

 

[olivia824]

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

 

[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

 

[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

 

[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

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

 

[Myrna Larson]

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