• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PTO Tracker and Leave Balance


Hello Gurus,
I have a spreadsheet that tracks paid time off accrual rate, paid time off and the balance of leave. Column C (PTO Accrual Rate (Per Pay Check) and I want to show 0.77 when employee's get paid as per Pay Date (Column B). For example, if today is 07/27/2020 then it should 0.77. For previous pay dates it should still show 0.77, but for any future dates it should 0.00 or blank. I have attached a sample workbook

Really appreciate your help.