Can someone help me create a contract in Excel?

Asked By 0 points N/A Posted on -
qa-featured

Hi guys,

Can someone help me create a contract in Excel?  I need a formula to automate the months remaining out of the contract.  I use Microsoft Excel 2010 on a Windows XP desktop.

Thanks in advance.

SHARE
Answered By 5 points N/A #148039

Can someone help me create a contract in Excel?

qa-featured

Hi Dudley,

Though your requirements aren't complete, I tried to improvise and created a simple Excel calculation With regards to your inquiry.  In this instance we will be using the MONTH, YEAR, and NOW Excel functions in calculating the months remaining in the contract. I had used the following steps in acquiring the remaining month of the contract.

  1. Using the Round Up function of Excel we will acquire the month of the .

    • This method only uses the month and year in calculation.
  2. In my example – see attached Excel file; in cell B2, I used the "=NOW" function.

    • The NOW function sets the current date and time by reading the computer's serial date.
    • The user is not required to input any data on this cell.
  3. In cell B3, the user may input the end date of the contract.
  4. For this method, we use the following formula in cell B4 –  "=(YEAR(CurrentDate)-YEAR(EndDate))*12+MONTH(CurrentDate)-MONTH(EndDate)"
    Or
    "=(YEAR(B3)-YEAR(B2))*12+MONTH(B3)-MONTH(B2)"
  5. The number that is returned in cell B4 is equals the number of months from today's date to end date of the contract rounded up to the next whole number.

    • The user is not required to input any data on this cell.

Hopefully I had helped you out with your contract automation.

Related Questions