Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown Formula
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,"erro r",(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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown Formula
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:) --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown Formula
so how would I put which days I didn't want in U4:U8? In what format?
--- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown Formula
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) "ianripping " wrote in message ... so how would I put which days I didn't want in U4:U8? In what format? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown Formula Error | Excel Worksheet Functions | |||
Unknown formula - not in help | Excel Worksheet Functions | |||
Unknown Formula: R[-1]c/r[4]c[-6] | Excel Discussion (Misc queries) | |||
Unknown Formula | Excel Discussion (Misc queries) | |||
Formula to look for value in a row depending on unknown value? | Excel Worksheet Functions |