I have a formula resulting in "days until event". I want to display it as
[#years]a [#months] if more than one year
[#months] [#days] if more than two months
The stupid idea was to use "[>365]JJ\a MM;[>60]MM TT;##" (german template), until I found out that it wants to format a date that way, and is one month off for the "months days" format. E.g. 70 days are "03 10" instead of "02 10" or similar because the 70th day in a year is 10-March.
Any way to be more smart than that?
Note: The formula used to build the value is somewhat complex, and I don't want having to use additional cells, so building another formula around that for "formatting" should be avoided (but would be an option of last resort).