julian date

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...

I am trying to create a field with a default Julian date containing only a single digit year - example today 10/26/2016 = 6300 - I understand that both 2006 and 2016 will produce a 6, using the single digit year Julian Date- but it's what they use, so...here I am. I have no issue creating the...

I'm querying a linked table and trying to reformat the date to yyyymmdd from yyyyddd example data DATA OUTPUT 2015001 2015/01/01 2015125 2015/04/05 what I have now in he query OUTPUT: Left([DATA],4) & "/" & Right([DATA],3) 2015125 2015/125 which only gets me to so far I...

I needed VBA code for turning today into a Julian Date. I finally got it to work and thought I would share... Sub Julian() Dim AWB As WorksheetFunction, JulianDate As String Set AWB = Application.WorksheetFunction JulianDate = AWB.Text(AWB.Days(Date, 1) - AWB.Days(DateSerial(Year(Date), 1...

I need to convert a date into a serial number. The serial number must return the format DDDYYNN where DDD is the day of the year, YY is the year, and NN is the sequential build number. As an example, if 10 units are built on 2/6/2013, the serial numbers would be 0371301, 0371302 ...0371310. Cell...

I have an excel document with two Sheets. Sheet One (Worklog) displays my daily work log. Column A on Sheet One lets me choose work tasks from my list on Sheet 2. Sheet 2 (List) has a list of tasks that I do each week. The task I am concerned with in the list is End Day. So in my first Sheet. I...

I need a Julian date turned into a standard date. However, the only catch is the Julian date is attached to a company code. E.g., I need to be able to take the 300 from 300XXXX and turn it into 10/27/2010. Then I need to be able to turn 10/27/2010 to 10/27/2011 (our product has an expiration...