Hi!
So in cell A2 I have a date which is written as: mon sept 6 fri sep 24
In cell B2, I have it set up to where it extracts the month (which would be September) and in cell C2, it extracts the date (which would be 6). But if there are 2 different months inside the cell it does it perfectly.
I was wondering if anyone knew how I can extract both dates dates for september.
I'll post up sample data that I have.
Thanks for all the hlep!
Bookmarks