Adding value automatically over time

I have a waitlist with several hundred people listed, different people are given points based on different criteria. Everyone earns one point after being on the waitlist for one year.

In Column F I have the date the person was entered onto the waitlist, in column G I have the points listed.

Is there a formula to automatically add one point to each person after they have been on the list for one year, and an additional point for every year after?

 

Thank you in advance!

 

 

By: Toby

Leave a Reply

Your email address will not be published. Required fields are marked *