Assigning a value to one cell based on the date in another... And then doing it again

K

Kristyn

Hello,

I am working on a spreadsheet that is tracking additional vacation hour
earned by employees as a result of perfect attendance.
For every 3 months of zero issues an employee earns an additional
hours of paid time off.

In column A I have listed the date of an employee's last incident
Column B is formulated to show the date in which the employee will b
rewarded the additional hours (assuming there are no further incidents)
Column B is also formulated to turn green when today's date matches th
reward date.

Is it possible for column C to automatically add a value of 4 whe
Column B matches today's date? If so, is it possible for column B t
repeatedly add 4 to its pre-existing value as column B reaches the nex
date of significance (I will be manually adjusting column A)?

If anyone is willing to share their knowledge/insight into this matter
it is greatly appreciated.

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

Return multiple values in one cell doing a single value lookup 4
Rank columns based on value in another column 1
update date when value in another cell changes 1
Summing cell values based on the value of another 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
Copy values from a cell based on values of another cell 4
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9

Top