Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date array shifting
Hi!
Make that range absolute: =MAX((NETWORKDAYS(C3,H3, A$44:A$64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0) Biff "kimdnw" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date array shifting
Thanks, Biff!
Kim "Biff" wrote: Hi! Make that range absolute: =MAX((NETWORKDAYS(C3,H3, A$44:A$64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0) Biff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array | Excel Worksheet Functions | |||
Date difference | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |