I have a spreadsheet with codes and dates. I would like the date to change based on the code and the code to change if the date is > the last day of each year. I have attached a practice file.
I have a spreadsheet with codes and dates. I would like the date to change based on the code and the code to change if the date is > the last day of each year. I have attached a practice file.
Last edited by Wskip49; 07-09-2012 at 12:03 PM. Reason: File did not attach
Can't see any attachment.
Pete
I when back and reattached the file. Sorry it did not work the first time. I've tried Vlookup formula but I would have to change each year.
Last edited by Wskip49; 07-09-2012 at 12:54 PM. Reason: Need to add more information.
So it looks like the
date = VLOOKUP(code)
Is fine, no problem? Anyway the cells beneath (A3:A5 etc) don't make much sense to me.
Probably... I don't understand the logic fully, but I'm guessing you want something like,
code = "VA-"&RIGHT(YEAR(TODAY()),2)
That will return the text string "VA-" with the two-year date for now attached. You can bury that in an IF conditional if you want, something like,
code = "VA-"&IF(date_check > date_ref, Right(Year(Today()) - 1, 2), Right(Year(Today()),2)
Anyway, that's the direction I'd go if I was the King of Space.
Thanks, I guess I did not explain my problem well enough. I tried your suggestion but could not get it to do what I wanted it to do. Sorry I for the waste of time. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks