This site needs Javascript to work, enable it by following the instructions here.
All files here are free, donations will go towards more files being created.
↑ Sign up to the RSS Feed for alerts when new files are added.
You may need to install the Analysis Toolpack/VBA, click Tools - Add-ins, tick them and then click OK
When you add the year to cell C2 on the Jan sheet the days in row 8 will update to match. Enter the Names in column A, Total Days Holiday Available in column B and copy down the formulas in columns C-E to match.