Something tells me this may be simple, but who knows. I've got a sheet with dates listed in a column as mm/dd/YYYY OR YYYY format, but need those dates to be constrained to just the YYYY portion. Is there a formula I can use for this? I know excel doesn't natively include just a YYYY format.
Thanks in advance!
Bookmarks