Excel calculator issue

sg111 - Oct 3, 2018 at 12:00 PM

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.