Calculating Days of the Week

S

snakeoids

Greetings,
I have a worksheet that has the following columns:
Date Received
Date Completed

I want to input a formula into another column that will reflect the number
of "working days" between these two values (no weekends or holidays). How
can I do this.
Please note that if excluding holidays is not possible then I can live with
it. Thanks.
Rod
 
F

Frank Kabel

Hi
=NETWORKDAYS(A1,B1)

Note: you must install the Analysis Toolpak Addin for this function
 
S

snakeoids

Hi Frank,
That does work quite well. Thank you. I have one last question and then
I'm set. If the value in the "Date Completed" cell is not a date but text or
something else I would like the cell with the Networkdays function in it to
remain blank until a date value is input in the cell. I image an IF
statement would do, but I don't know quite how to do it. Can you help
please? Thanks Again.

Rod
 
A

Aladin Akyurek

=IF(N(DateCompleted),NETWORKDAYS(DateReceived,DateCompleted,Holidays),"")

Holidays refers to a range that houses the holiday dates.
 

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

Display weeks from a Milestone 0
Date Calculation Formula- Calendar days minus Holidays 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Calculating days spent to complete a task 2
Calculate days help 2
Alternative formula to exclude holiday calculation 6
MS Project. Real progress of the project, % complete 1
Date Calculation question 3

Top