Project Time in a year formula

N

niallf

Joined
Jul 29, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allocate an income payment over a date range (tax years) 7
Formula to figure out months between two dates 3
Calculating Annual % Increase that occurs mid month 8
Lookup expiration dates by calendar month 4
Return value from a Two Variable Data Table with Dates 1
Funds allocation by Calendar Year 3
Create dates for year, allow for leap year 8
Conditional summing across several sheets 2

Top