Hi!
How can I convert a date like this 01/12/06 into one that looks like this Jan-06 so that a sumif or lookup will get all dates that fall in January of 2006. Formatting does not do it because the functions still reads it as 01/12/06.
Any help or direction would be greatly appreciated!! Thanks!!