Forum Discussion
Solved
Shorter way of extracting and matching date
Hi all! Let's say my current workbook is named CurrentWB and the headers I'm working in are formatted like so: X_2020_01 (X = variable prefix, 2020 = year, 01 = month) Part of my formula to matc...
You can also use TEXT([@[StartDate]];"jjjj\_mm")
The \ tells Excel to treat the _ after it as a literal character.
HansVogelaar Even better! This had a strange but positive side effect: I had to note the month as "mm" instead of "mmm" as explained above. which saves another character on the 19 characters saved additionally. That's 117 characters per cell less in total. On over 50,000 lines and dozens of columns, that makes a pretty huge difference 🙂