I have a column of dates in Column A that generate with a formula like so:
A1 "=O18" (This is currently a date that is inputted by the user.
a2 "=b1+1"

Column b is like:
b1 "=a1+13"
b2 "=a2+13"

(Quotes are used here to indicate the formula I am using in the cells)
These formulas go down about 57 cells. I would like to automate this so
that when the last cell is equal to (Or greater than) today, cell A1 will
automatically change to the date in the last cell. Any help in how to do this
would be greatly appreciated!

Thanks,
Tim