March 10, 2016
In the attachment - I took a table that I brought from software into Excel
I downloaded all the unnecessary columns and left only the date
The date is written to me in a number - how do you turn it into a date structure ???
Thanks so much for the reply, Leah
December 20, 2019
October 5, 2010
So the number 202104 is what you want to convert to a date? I assume that represents April 2021 so there is no day specified, in which case I'll just ise the 1st of the month.
You can use this formula
and set the cell to Date type - see attached.