ContributionsMost RecentMost LikesSolutionsRe: Calculate contract lengthYes, 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 ------------------------------ Re: Calculate contract length 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 ------------------------------ Calculate contract lengthI 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 contracts that are less than one year hence the months field. The problem I am encountering is the contracts are based on an academic year (08/01 - 05/31) and I do not know how to build a formula to capture a specialized date range. We have 2 types of contracts: Example: contract 1: 08/01/19 - 5/31/23 = 4 year length academic contract Example: contract 2: 08/01/19 - 07/31/23 = 4 year length annual contract (non-academic) I also cannot figure out how to calculate only months for those contracts that are less than 1-year. ------------------------------ Jaclyn Schlipp ------------------------------