ExcelBanter - How do I add value to a cell based on the calendar?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add value to a cell based on the calendar? (https://www.excelbanter.com/excel-worksheet-functions/155168-how-do-i-add-value-cell-based-calendar.html)

LoriKLynn

How do I add value to a cell based on the calendar?

I would like to create an Earned Leave report for my company. My company
accrues sick time for each employee at a rate of 8 hours per month on exactly
the 16th day of each month. Is it possible to create a formula so that the
value in the cell increases by "8 hours/month" automatically on the 16th day
of each month?

It might be a long shot but I figured I'd just ask. Thank you.

Teethless mama

How do I add value to a cell based on the calendar?

=SUMPRODUCT(--(DAY(A1:A100)=16))*8

"LoriKLynn" wrote:

I would like to create an Earned Leave report for my company. My company
accrues sick time for each employee at a rate of 8 hours per month on exactly
the 16th day of each month. Is it possible to create a formula so that the
value in the cell increases by "8 hours/month" automatically on the 16th day
of each month?

It might be a long shot but I figured I'd just ask. Thank you.

All times are GMT +1. The time now is 12:00 PM.