Hello, I'm hoping someone can point me in the right direction here, I've found this site very helpful in the past.
I built a simple tool to help me calculate codes and dates based on Julian dates...for example, I need to know the Julian code for a date 45 days from today...1001...but the future code has to start with a 2 in order to distinguish it as a a future code in our system....so I used a formula to add 1045 to any code in the "Use by 45" field...and it correctly gives me 2046. Here is the problem...when I get to the end of the year, I need it to change to a 3XXX format when a date is reached past 2365. So now just adding 1045 doesn't work...if I do that to Dec 15th's Julian (1349) I get 2394....but I need it to recognize a new year starts after 2365 (2+365days) and give me 3029. Which is 45 days past Dec 15...into a different Julian year, changing the first digit 2...into a 3...then giving me the day in a 001, 002, 003 format.
To clarify...Jan 1 of next year needs to read as 3001...not 2366...how do I add a formula that looks for a number over 365 and changes the output to what I need? I have "use by" categories 45, 90, 120, 150, 180 and 210....so there will be lots of times when the date I need gets pushed past the next year
