Using Julian dates and Calculations

Occasional Contributor

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 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 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 there will be lots of times when the date I need gets pushed past the next year

2 Replies
best response confirmed by Mkolpek (Occasional Contributor)

@Mkolpek Made some modifications to your schedule. See if that does what you have in mind.

Screenshot 2022-01-01 at 11.11.39.png

Genius, works great...thanks!