NETWORKDAYS

lascough

Board Regular
Joined
Oct 31, 2003
Messages
74
With help from Mr Excel members I have been able to create a spreadsheet which can calculate the number of days passed between two dates. The following formula works (where A9 is the start date and J9 the end). I have used the -1 at the end to knock off the date of ordering.

=IF(OR(A9="",J9=""),"",NETWORKDAYS(A9,J9))-1

The thing is, when no dates are enetered the cell displays #VALUE.

I have tried using ISERR and ISBLANK to correct this but I must be doing something wrong as I can not get it to work.

Any ideas???
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Just move the last paranthesis:

=IF(OR(A9="",J9=""),"",NETWORKDAYS(A9,J9)-1)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,322
Members
412,716
Latest member
thviid
Top