Posted to microsoft.public.excel.programming

ianripping[_28_] ianripping[_28_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unknown Formula Error	Shaunna H.	Excel Worksheet Functions	2	February 4th 09 07:14 AM
Unknown formula - not in help	CrazyEd	Excel Worksheet Functions	1	October 25th 07 07:07 PM
Unknown Formula: R[-1]c/r[4]c[-6]	Clare	Excel Discussion (Misc queries)	2	April 3rd 07 09:45 PM
Unknown Formula	Lucky_guy2000	Excel Discussion (Misc queries)	4	April 28th 06 04:22 PM
Formula to look for value in a row depending on unknown value?	pcsski	Excel Worksheet Functions	2	April 25th 06 08:25 PM

All times are GMT +1. The time now is 02:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us