Hello, I have built a workflow in Excel that needs to process a column of dates that are often in multiple formats and extract only the year from the end of these multiple formats for further calculation. I've not made use of VBA for this section either. The problem is that Excel keeps instantly recognising the dates and formatting them as dates, so that when I try to extract them as text (or values) in another column, they show up as unintelligible numbers. Sometimes Excel does not do this, and the workflow is successful.
Can anyone suggest a way to extract the entire column simply as the TEXT so I can use LEFT and RIGHT functions to extract the year?