Darren Smith
Well-known Member
- Joined
- Nov 23, 2020
- Messages
- 631
- Office Version
- 2019
- Platform
- Windows
My date data is very messy I need to have help to solve it.
I`ve put my workbook in the forum please look at column D on the first tab it has a fair number of different ways of declaring dates or weeks No,s.
So how are we to sort this into months on power query or VBA?
I`ve added a filter to show the ones which are unclear?
I`ve put my workbook in the forum please look at column D on the first tab it has a fair number of different ways of declaring dates or weeks No,s.
So how are we to sort this into months on power query or VBA?
I`ve added a filter to show the ones which are unclear?
Transfer - Dropbox
Dropbox is a free service that lets you bring your photos, docs, and videos anywhere and share them easily. Never email yourself a file again!
www.dropbox.com