calculates number of days less than or greater than x (a specific date)

**t2dela** · 04-07-2013, 03:44 AM

I’m creating a spreadsheet that has a start and end date that overlaps in years. If I enter
A1 = start date (03/05/2012) and
A2 = end date (4/25/2013),

A3 = calculate the number of days in 2012, if applicable (days that is less or before than 12/31/2012) and
A4 = calculate the number of days that is greater than or after 01/01/2013.

**benishiryo** · 04-07-2013, 03:51 AM

hi t2dela, welcome to the forum. maybe you could share with us what are the desired results. my guess for A3 & A4:
=DATE(YEAR(A1),12,31)-A1
=A2-DATE(YEAR(A2),1,1)

do a +1 if necessary. some people define 26apr13 minus 25apr13 as 2 days or 1 day.

**t2dela** · 04-07-2013, 04:01 AM

benishiryo, thank you for responding. That answers part of my question. However, I don't want A3 to calculate anything if the date is after Dec 31, 2012 and i only want A4 to calculate dates after Jan 1, 2013.