Calculate contract length
I am trying to calculate the length of a contract using the start date and end date of the contract. I have a field for contract length (years) and a field for contract length (months). We do have ...
Forum Discussion
I'm not entirely sure I understand your first question. Are you looking to calculate the contract for years and months for the 4 year contracts?
For your second question:
Month(End Date) - Month(Start Date)
------------------------------
Paul Peterson
------------------------------
For your second question:
Month(End Date) - Month(Start Date)
------------------------------
Paul Peterson
------------------------------
Hi Paul,
I need to calculate lengths for all contracts. The 4-year contract was just an example.
Scenerio 1:
Contracts have an appointment term based off of an academic year (Aug - May). There can be 1 -6 year terms per faculty. We are manually entering an appointment start date (08/01) and appointment end date (5/31) into QB and would like to have a field that calculates the lengths per dates of appointment.
Scenerio 2:
Contracts have an appointment term based off a 12-month year (Aug - Jul ; Jul - Jun; Oct - Sep; etc).
Scenerio 3:
Contracts have an appointment term of less than a year (Aug - Dec; May - July; Sep - Jul; etc).
Thanks!
Jackie
------------------------------
Jaclyn Schlipp
------------------------------
- Let's see if I have a better grasp now.
You need three calculations.
One is based on a school year and you need to calculate the number of years remaining. The next one is a multi-year contract based on a rolling calendar. And the last is set for a given number of months. Is that how you want the calculations?
------------------------------
Paul Peterson
------------------------------- Yes, you got it.
To make it a bit clearer:
1) Academic Year contract: Aug - May (how many years appointed per term of contract 1,2,3,4,5,or 6)
2) Academic Semester contract: Jan - May (spring) or Aug - Dec (fall); term will always be 5 months
3) 12-Month contract: the annualization factor is 12 so the less than 1-year appointments (non-academic) can fit here
Hope this helps.
------------------------------
Jaclyn Schlipp
------------------------------- I would recommend setting up a Formula Numeric Field and 1 would be equal to 1 year and less than 1 is a fraction of the year. Your formula would simply be
If ((Year([End Date])-Year([Start Date]))=0,(Month([End Date])-Month(Start Date]))/12.0,Year([End Date])-Year([Start Date]))
------------------------------
John Crosland
Software Developer
Inglett & Stubbs
Mableton GA
------------------------------
