Whenever Google Analytics exports a date, it shows up as
The best way to make it into a format usable by excel is to use the Text to columns button.
I chose 'Delimited', but uncheck all of the different delimiters. Then on the Column Data Format page of it, I choose date.
I wanted to create a macro that looks for a column with the header "Date" and then applies this formatting to it.
Thank you for helping me out!
Date |
20220117 |
20220118 |
20220101 |
20220102 |
20211227 |
The best way to make it into a format usable by excel is to use the Text to columns button.
I chose 'Delimited', but uncheck all of the different delimiters. Then on the Column Data Format page of it, I choose date.
I wanted to create a macro that looks for a column with the header "Date" and then applies this formatting to it.
Thank you for helping me out!