Posted to microsoft.public.excel.misc

kimdnw

Posts: n/a

date array shifting

In my worksheet I have the formula:
=MAX((NETWORKDAYS(C3,H3, A44:A64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0)

(thanks to Bob Phillips for the basics and Sloth for the =MAX(formula,0) to
avoid negative number displays)

So for the portion of the formula (NETWORKDAYS(Start date, Finish date,
Holidays)-1), is there a way to keep the holiday range from shifting as I
copy the formula down the page?

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
Array	Brad	Excel Worksheet Functions	9	October 17th 05 09:00 PM
Date difference	Maxi	Excel Worksheet Functions	7	July 28th 05 01:38 PM
Date Math Problem	Dkline	Excel Worksheet Functions	4	March 4th 05 04:11 PM
date and time	ladimples247	New Users to Excel	2	February 16th 05 08:52 PM
Need help troubleshooting an array formula XLXP on Win2K	KR	Excel Worksheet Functions	1	December 13th 04 07:41 PM

All times are GMT +1. The time now is 01:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us