08 January 2025 13:30
Custom Date format to comply with Canadian Food Regulations
by _Nico (via)=DATE(20&LEFT(A1,2),LOOKUP(MID(A1,4,2),{"AL","AU","DE","FE","JA","JN","JL","MA","MR","NO","OC","SE"},{4,8,12,2,1,6,7,5,3,11,10,9}),RIGHT(A1,2))
1
(2 marks)