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

G

Guest

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

How to set up a formula that it adds value on a certain date 5
Vacation accrual based on years with rollover 1
How do I assign a numeric value to a letter 1
How do I calculation vacation accrual? 1
Pull a value from another worksheet 2
How To Create a Value Based Upon The Contents of A List 2
if statement = if number is between 1
Sum Number of Rows based on Value in Another Cell 2

Top