Good Morning All,
I have a spreadsheet that I need to provide analytics on. One of the most important factors in the analytics is to analyse the data over time, the only issue is the format in which they have been storing the date. The question is very similar to this problem but for excel:
how do I convert mmyy to last day of month in netezza
or this question:
Create a date from Credit Card expire in MMYY format
Essentially I have a column filled with dates that have been written as mmyy i.e.
0215 0215 0215 0315 0315
The column has been saved as the data type: "Special". How do I convert this data into a useable format? I don't mind if we put it into dd/mm/yyyy and use the first or the last day of the month that's fine. Is there an excel function that I could use or is this something I would have to do in VBA? and if so, how?
Aucun commentaire:
Enregistrer un commentaire