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.
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.