Jump to content

Dal357

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by Dal357

  1. In case anyone comes across this with the same issue, the following worked for me (in both Excel and Google Sheets): =year(datevalue(a2)) It converts the text to MS date code, then takes the year. Regards, Dal
×
×
  • Create New...