Mandalorean2356
New Member
- Joined
- Jun 6, 2021
- Messages
- 1
- Office Version
- 365
- 2016
- Platform
- Windows
Any help would be great. I'm in the military and we use Julian dates to track alot of inventory. Each year we need audit our items and we do this by checking the Julian dates adding its shelf life by months and getting its due date. This is all done on scratch paper. I'm trying to create an Excel Sheet where I enter in the needed information. I enter in the Julian date add the months and get a calendar year in my total. I have managed to get a conversion from Julian to calendar in Excel using =("1/1/"&(IF(LEFT(A6,2)*1<20,20000,1900)+LEFT(A6,2)))+MOD(A6,1000)-1. My biggest hurddle is having Excel give the proper day. Every total comes out in a leap year and nothing in perpetual (non-leap years), It would be great if the formula knew when to give a leap year and a perpetual year. if anyone knows any formula which might help that would be great. *First Post*