Date in cell in odd format (Mon Jun 20 10:41:45 GMT 2022)

[Mccollantics2022]

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.

Thank you

[TMS]

Try:

Please Login or Register  to view this content.

formatted as time and copied down.

It's just text representing a date and time.

[Mccollantics2022]

When I try this on column M (Creation) it doesn't like the formula. I changed the letter from B to M in each case. Do you know why?

Thank you

[Mccollantics2022]

I've tried it and it works on B (but not M - see comment above) but the array doesn't pull through the dates to other sheets.

[TMS]

Works for me:

Please Login or Register  to view this content.

[Mccollantics2022]

It works! Thank you. I'm just comparing yours to mine to see why my changes didn't work.

[TMS]

You're welcome. Thanks for the rep.


It'll be something silly. Mistakes we all make