Annual leave planner

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Re: Annual leave planner


    Hi kennethbrandon -


    For the conditional formatting, highlight cell H8 and make your conditional format formula read:


    =$D8<>""


    and then drag down the formatting.


    For the Total Annual Leave (column AM), this formula works for me:


    =IF(SUM(AK8-AL8)=0,"",SUM(AK8-AL8))


    Hope that helps!

    Re: Annual leave planner


    Hi abba92,
    Thank you very much for sharing with me.
    The Total sum for column AM works perfectly! I have used your formula for Conditional Formating but it does'nt work when the week end "Sunday" and Year changes. Is there any other alternatives besides =$D8<>""? Thanks again.

    Re: Annual leave planner


    Hi kennethbrandon - Highlight E7:AI52 (with E7 as the active cell) and conditional format using the formula:


    =WEEKDAY(E$7,2)>6

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login