Unknown Formula

  • Thread starter Thread starter ianripping
  • Start date Start date
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
 
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:)
 
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)
 
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)
 
Back
Top