Hello all, I have an name in a1, a date in a2 and a number in a3. ( Tom 03-17-11 1 ) . I would like the a3 cell to go a 1- , that is drop off one year after the date in a2. I have used =edate(a2,12) in cell b2. Can I turn the 1 that is in a3 into a 1- when b2 get to 03-17-12.
PS. This is my first post. I have seen some great thing in this forum and look forward to learning alot and even helping when I can :-)
Bookmarks