Apple numbers formula for date on the nth day of a given year
Has anyone a formula in numbers that will show the date when given the nth day of a given year?
eg
A formula that would return “3rd March” given 2018 (year) and 62 (number of days).
This formula should return “2nd March” if given 2024 (year) and 62 (number of days) since 2024 is a leap year.
Aware I could build a look up table, and work something out for multiples of four to account for leap years, but that feels like a clumsy solution.
Any ideas folks?