Unknown Formula

I

ianripping

Hi I have come accross a workbook with this formula. Can anybody work i
out?

=IF(ISERR(NETWORKDAYS(A4,F4,$U$4:$U$8))=TRUE,"error",(NETWORKDAYS(A4,F4,$U$4:$U$8)))

In A4 and F4 There are dates, and in U4:U8 there is nothing entere
into the cell.

I think it is menat to work out the number of Working Days between th
two dates.

Can anybody help
 
R

Rockee052

Hi Ianripping,

The Formula you have listed in your post counts the workdays "Monday -
Friday" in the aruments. A4 is the start date and F4 is the end date.
$U$4:$U$8 are days you want to be excluded from the working calander
calander.Also, $U$4:$U$8 is optional.

Rockee:)
 
B

Bob Phillips

Ian,

These are dates. It is referred to as holidays in the help, and normally
would be, but it can be any dates that you want to exclude.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

NETWORKDAYS automatically excludes Sat and Sun so you don't need to do
anything.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top