I've got a file with dates entered as year-month:
15-May
16-Mar
7-Jun
These are meant to represent
5/1/2015
3/1/2016
6/1/2007
Unfortunately, they were saved in a date format that makes Excel see them as being a month and day in 2019:
5/15/2019
3/16/2019
6/7/2019
How can I convert them into the correct date format (15-May should be 5/1/2015, as I have only month and year for each value)?
Thanks!!!
15-May
16-Mar
7-Jun
These are meant to represent
5/1/2015
3/1/2016
6/1/2007
Unfortunately, they were saved in a date format that makes Excel see them as being a month and day in 2019:
5/15/2019
3/16/2019
6/7/2019
How can I convert them into the correct date format (15-May should be 5/1/2015, as I have only month and year for each value)?
Thanks!!!