Hi,

I am trying to track timeshare points I have. I get 29000 point (called new points) on 8/1 every year and they are good for 2 years. However, they lose value when they rollover to the second year (called saved points).

What I want to do on Aug. 1st each year is:
  1. have the data in cell F2 (new points) move to G2 (saved points)
  2. Have the data in G2 (saved point) move to H2 (expired points)
  3. have the data H2 (expired points) keep a running sum of points that might expire over the years


I also can't figure out how to have text and numbers in the same call and be able to have that cell be used in a formula to sum cells.

Thank you,
Mike