I have a sheet where I am tracking dates pertaining to certifications. The issue is that some certifications have only a year (yyyy) (2013, 2007, 2020, etc.) or they have an exact date that I need to put in a dd mmm yy format (06 Jun 19, 15 Jan 07, 33 Oct 20). Some people also don't have the exact dates from their certification, in which case I can only use the year. These two date formats need to be interchangeable in the same cell.
When I use ctrl+1 and use the custom tab to format the dates to one of these options I get issues when I need to enter the other date format. It's not only the wrong format but it will also change the date to something completely random (I'll type in 01 Jul 20 and it'll change to 1905 or I type in 2022 and it changes to 15 Jun 05). I'm not very excel savvy but it's something I've been tasked with at work. Help?
When I use ctrl+1 and use the custom tab to format the dates to one of these options I get issues when I need to enter the other date format. It's not only the wrong format but it will also change the date to something completely random (I'll type in 01 Jul 20 and it'll change to 1905 or I type in 2022 and it changes to 15 Jun 05). I'm not very excel savvy but it's something I've been tasked with at work. Help?