Iccreamann21
New Member
- Joined
- Sep 25, 2013
- Messages
- 48
- Office Version
- 365
- Platform
- Windows
Hello, Good Morning, Happy 2024,
Quick questions, the data I am exporting has the column "Closed Date" and what I'm looking to do is extract just the name of the month.
Currently, I am doing this way and it works, but Im trying to eliminate having to add the cheater cell and the AA:AB table.
Any help will be appreciated. Thank you
Quick questions, the data I am exporting has the column "Closed Date" and what I'm looking to do is extract just the name of the month.
Closed Date | Month Name |
12.21.2023 | December |
Currently, I am doing this way and it works, but Im trying to eliminate having to add the cheater cell and the AA:AB table.
Closed Date | Cheater | Month Name |
12.21.2023 | =left(A2,2) | =vlookup(B2,AA:AB,2,0) <- then create a table in column in AA:AB |
Any help will be appreciated. Thank you