Calculating # of days

[jhorness]

I have two inputs, the date the equipment goes out and the date the equipment comes back in. I know I can subtract the two dates to get the total # of days, but what I need to do is calculate the number of days per year.

Ex) Say the out date is 4/1/09 and the in date is 12/31/2011. I need to calculate the number of days for 2009, 2010, and 2011.

I'm drawing a blank. Thanks

 

[texasalynn]

subtracting them and formula both return the same number

Excel Workbook
	C	D
23	4/1/2009
24	12/31/2011
25	1004	1004
Test

 

[jhorness]

I need to calculate how many days are in 2009, 2010, 2011. I know that the total number of days is 1004, but 275 are in 2009, 365 days each for 2010 and 2011. Anybody know how I can do this? Thanks

 

[al_b_cnu]

this returns 1006:

=DATE(YEAR(TODAY())+3,1,1)-TODAY()

 

[jhorness]

This doesn't get me to the count of days for 2009, 2010, 2011.

If I enter the dates of 4/1/09 to 12/31/2010, I need the output to look like:

2009 2010 2011
# of days 275 365 365

I just don't know what formula to use to get to 275, 365, 365.

 

[texasalynn]

does this work

Excel Workbook
	A	B	C
1	1/1/2011	1/1/2010	1/1/2009
2	365	366	1006
Sheet1

 

[barry houdini]

Try like this...see below

D1:H1 are just years as numbers as displayed, not dates...

Formula in D2 copied across and down

=MAX(0,MIN($B2+1,DATE(D$1+1,1,1))-MAX($A2,DATE(D$1,1,1)))

Book3
	A	B	C	D	E	F	G	H	I
1	In	Out		2009	2010	2011	2012	2013
2	01-Apr-09	31-Dec-11		275	365	365	0	0
3	13-Mar-09	31-Mar-13		294	365	365	366	90
4
5
Sheet3