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

L

LoriKLynn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calc staff vacation time based on more than 1 criteria 0
How to set up a formula that it adds value on a certain date 5
Vacation accrual based on years with rollover 1
use month in cell date to sum all relevant cells 2
Summarizing multiple worksheet data 0
How do I use the IF function with info that contains a date? 1
Calendar Logic: Recurring Dates 3
Define a Range based on Cell Values 2

Top