Pivot tables

Hello Barbara

Thank you for your question.

If the spreadsheet records the start date and withdrawal date in separate cells, then you can use the DATEDIF function to calculate the difference between the two dates, and express the difference in years.

If a student starts and withdraws in the same year, then the result will appear as a 0; if the student starts in one year and withdraws in the next, the result will be 1 etc; so you will need to add 1 onto the result of the formula.

Please note the DATEDIF function does not appear in the function wizard and there is no Help topic for it so you will need to type it into the spreadsheet manually.

I've attached an example; the formula is in the yellow cells.

I hope this helps.

Kind regards
Amanda