8 Replies Latest reply on Jul 21, 2010 3:57 PM by ChrisElliot

    calculating the number of days within a period of time.

    ChrisElliot

      Title

      calculating the number of days within a period of time.

      Post

      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.