Hello all, i have an issue with converting a type of ... julian date... to a regular date and my brain must simply not function today so i am requesting help.

i have a serial number: 09121673 for example

09 is the month 12 is the year 167 is the day and the last digit is ignored.

i am using this formula i found on here to do the date conversion: =("1/1/"&(IF(LEFT(A4,2)*1<20,2000,1900)+LEFT(A4,2)))+MOD(A4,1000)-1

it works but the month and year are switched i believe and again, i simply am having a "brain fart" moment today and cannot seem to figure it out!

thanks!!