Calculate the number of days in any given year

Closed
Mandy - Feb 25, 2015 at 07:42 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 25, 2015 at 11:34 AM
Hello,
I am trying to determine how many days in each year so I can calculate costs based upon the number of days. I have the following columns

Commencement Date
25/2/2015
Completion date
24/2/2018
If they ask for an extension there is a further column New Scholarship extension but the value remains the same as the original date unless an extension is granted, so currently the date is.
24/2/2018

I was trying to determine how many days in 2015, how many in 2016, 2017 & 2018. I have separate cells for each of the years but cannot figure out a formula to work it out.

Many thanks,
Mandy

1 response

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Feb 25, 2015 at 11:34 AM
Could it be that you've entered the dates as text rather than a value?
0