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.