Very cool! I’d simply write a formula that checks if the year of the Ethiopian date is divisible by 4 and if so add 2,811 days to the date else add 2,810 days. So if it was a calculated column it would look something like this:
GregorianDate = IF(MOD(YEAR[EthiopianDate]), 4) > 0, DATEADD([EthiopianDate], 2811, DAY), DATEADD([EthiopianDate], 2810, DAY))
1 Like