PDA

View Full Version : Networkdays Formula



josephm
06-10-2008, 11:06 AM
i have used the formula before, however only on two dates.
can i use the formula on a range of cells

range = b3:cs3

dates coloured green are the start dates and red is the end dates
on the information sheet they are 10 names = 10 rows where dates will be entered
on the summary sheet i need a summary for each name and the total number of networkdays for each row

i have attached the sheet i am looking to test this on

~Please do not use all caps in your post-title (corrected).
Oorang

pnewton
06-15-2008, 03:45 PM
Hi Joseph

Had a leave / holidays template which I've modified slightly for your purposes. Different way of thinking but does what you're after. Also makes the viewing of who's on leave and when statutory holidays are, etc, easier to see and, of course easier to print.

Let me know if this suits.

Cheers

Pete

Bob Phillips
06-15-2008, 04:07 PM
You need to layout the SUMMARY sheet as you want to see it, we cannot kinow how the info should be.