Previous Topic Next Topic

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

Answer 1 / 1
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?

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

2 responses