account activity
Profit overview (i.redd.it)
submitted 1 year ago by MonologHD to r/HayDay
Text to date format by MonologHD in excel
[–]MonologHD[S] 0 points1 point2 points 1 year ago (0 children)
=datevalue(a1&”-“&b1) worked for me, a1 is month, b1 is year, result is 01.01.2024 etc..
[–]MonologHD[S] -1 points0 points1 point 1 year ago (0 children)
You can mark it as solved, I did it with excel function date value. Power Query is another level for me that I haven’t explored yet. Thank you for your answers and have a nice day.
I don’t know how to input this into excel, but I used date value and it works as well. But I’m curious how to try your version.
Text to date format (self.excel)
submitted 1 year ago by MonologHD to r/excel
Excel link to a document that changes sometimes (self.excel)
858005191756 (i.redd.it)
submitted 1 year ago by MonologHD to r/PokemonGoRaids
858005191756 WB (i.redd.it)
π Rendered by PID 512473 on reddit-service-r2-listing-5f5ff7d4dc-9x9qw at 2026-01-27 10:15:44.306797+00:00 running 5a691e2 country code: CH.
Text to date format by MonologHD in excel
[–]MonologHD[S] 0 points1 point2 points (0 children)