I have searched the web for answers but cannot seem to find how to modify these formulas. I have attached a working file. I would like to have Cell B4 represented by just the last three digits (305 instead of 14305).
Similarly, I would like to INPUT only three digits in Cell A5 and have the date represented in Cell B5. This may be more difficult to do.
Thanks!
Bookmarks