MS Excel 2003 on Win XP
I'm trying to figure out a formula to evaluate the number of project work days in a calender year, given just the project start date and the end date.
e.g.
Cell with project start date, say B1=1/6/2009
Cell with project end date, say B2= 2/4/2011
I've got 3 seperate columns for 2009, 2010 & 2011
Cell B3=Formula for project working days in 2009
Cell B4=Formula for project working days in 2010
Cell B5=Formula for project working days in 2011
I'm sure it's a combination of IF statement and Date Functions such as NETWORKDAYS, just doing my head in to figure out what combination.
Thanks, Niall
I'm trying to figure out a formula to evaluate the number of project work days in a calender year, given just the project start date and the end date.
e.g.
Cell with project start date, say B1=1/6/2009
Cell with project end date, say B2= 2/4/2011
I've got 3 seperate columns for 2009, 2010 & 2011
Cell B3=Formula for project working days in 2009
Cell B4=Formula for project working days in 2010
Cell B5=Formula for project working days in 2011
I'm sure it's a combination of IF statement and Date Functions such as NETWORKDAYS, just doing my head in to figure out what combination.
Thanks, Niall