Need a formula in cell C3 to show the last two digits of the year of a date in cell B2.
For example:
B2 = 12/31/2007 Need C3 = the number 07 or 7
or
B2 = 12/31/1997 Need C3 = the number 97
etc.
I tried putting in C3 =Right(B2, 2) but I get weird numbers.
Thanks for all you help. mikeburg
Bookmarks