Hello everyone,
Can anyone please help me, how to read these 2 formulas and what they're basically doing?
1.Created Date
=IF(ISERROR(DATE(LEFT(B2,4),MID(B2,6,2),MID(B2,9,2))),DATE(MID(B2,7,4),MID(B2,4,2),LEFT(B2,2)),DATE(LEFT(B2,4),MID(B2,6,2),MID(B2,9,2)))
2.Time
=TIME(MID(F2,12,2),MID(F2,15,2),0)
Thanks in advance!![]()
Bookmarks