I am trying to construct a spreadsheet to calculate the amount of annual
leave due to people when they change their working habits throughout the
year. I want to be able to show the person how the calculation has been
arrived at and also want to be able to re-use the spreadsheet time and time
again. I am using Excel 2003.

Can you please help?

Thank you.