New file, Slightly different formatting.

Dates are formatted conditionally, Weekends in blue text, Accrual dates with green background.

Broke out accrual into separate column, and revised balance formula to do sums only. Added grouping so past months can be collapsed.

One of the conditional formatting terms is a little clumsy. Excel 2003 doesn't seem to recognize EOMONTH in that context. So it had to be indirect.


Attachments
tonys_leave-2.xls (139 downloads)

_________________________
Glenn