I'm trying to import date data.
I failed importing as date format, so changed to text then succeeded.(below "week date")
Next I'm thinking that changes to date format.
So I tried using Mid function and Date function, but the value wasn't filled with cell.
What should I do or is there good way to import date??
Go to Solution.
Can you please share a screenshot of the date that you are trying to import into Week Date, so I can look at how the source date is formatted?
Hi @Takamasa ,
Year should be formatted like 2018,2017.. So concatenate 20 with Year.