I currently have a spreadsheet with 500ish renewal dates. I need to be able to take the renewal dates (dd-mmm) in column B and then display the current year with renewal date, if the date has not yet come, or the next year with renewal date, if the date has already passed in column C (dd-mmm-yy).
Thanks for the help.
Joe
Yearly countdown
-
-
-
Re: Yearly countdown
Attach a small sample please ...
-
Re: Yearly countdown
Here is a sample of what I am doing so far.
Thanks for the help. This is going to save me a ton of time. -
Re: Yearly countdown
So essentially if the renewal date is today, it should say 9-Mar-14. But if the renewal date has already passed, say, 7-Mar, it should say 7-Mar-15.
Thanks again.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!