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
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