I have julian dates from Epicor financials I'd like to convert to normal date format dd/mm/yyyy in MS Excel.
I googled fixes and also checked here on EE but I can't seem to fix my problem.
For instance one of the dates is 733013 which should give me 03/12/2007.
However my results are not correct for the year portion when I use this formula:
I keep getting 03/12/3966.
How can I fix this problem to get 03/12/2007 by using the same formula above (but corrected version) or any alternative formula?
Thank you kindly for your assistance.