I am trying to get the Excel sheet to calculate the age of a defect (how many days it has been open) but the extract from the Octane software has this date format: Mon Jun 20 10:41:45 GMT 2022.
I've never used VBA but I fear this may be a format that requires that sort of thing. Is there any way around this or is VBA the only thing and if so is it something a novice can do? See sheet attached. Please refer to the "Octane Extract Here" worksheet.