Requesting help with date function

Hi all,

I need some help writing a date formula. I have two columns, Column W with a start date, Column X with an end date. I want to calculate the number of days between the two and return them by what is related to a particular year (3 columns, one each for 2012, 2013 & 2014). Does anyone know if this is possible?

Thank you so much,
K

Kitkatlv,

If I understand what you're trying to do correctly then I think the following is what you're after. If this isn't what you're try to do, then maybe you could post more details or an example spreadsheet.

Start Date	End Date	Total Days	2012 Days	2013 Days	2014 Days
1/1/2012	11/30/2014	1064	365	365	334
3/1/2012	7/15/2013	501	305	196	0
6/1/2012	9/20/2012	111	111	0	0
12/1/2012	12/31/2014	760	30	365	365
		=B2-A2	=IF($B2<DATE(2012,12,31),$B2-$A2,DATE(2012,12,31)-$A2)	=IF($B2<DATE(2013,12,31),$B2-$A2,DATE(2013,12,31)-$A2)-D2	=IF($B2<DATE(2014,12,31),$B2-$A2,DATE(2014,12,31)-$A2)-D2-E2