calculating the number of days within a period of time.
Hi , I would be grateful for some help .
I am trying to come up with a formula to work out how many days a contract has to run within a specific year. For example the contract starts on December 1, 2009 and ends on Dec 1st 2010. I need to work out how many days of the contract are within the 2010 calendar year .
Any assistance with this is most appreciated.