I am trying to create an excel calculator to calculate the holidays a certain employee has accrued depending on a set of conditions. I want to try and see if i can create a formula whereby if today was 01st of Jan of this year, I want the excel to check if that condition satisfies and for it to 30 to the present quota of leaves to the present accrued leaves.
