I am needing a formula to generate a unique Julian date. The unique date is a combination of the Julian date, the fiscal year and a reference identifier. For example: Z994284.

Z99 is the reference identifier
4 is the fiscal year (24) that starts on October 1st. So, the fiscal year is now 2024 not 2023.
284 is the Julian date which is the number of day since Jan 01.

What I am hoping for is a formula which will return the correct unique date based on today's date.

Hope someone can help in this challenge. Thank you for any any help offered.