julian date

  1. M

    Julian Date to Leap and Perpetual

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

    Default field with Single Digit Year within Julian Date

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

    convert yyyyddd to yyyymmdd from and linked table

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

    VBA for Julian Date

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

    Date code serial number in excel

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

    VBA Script which adds a Julian Day to a 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...
  7. D

    Julian date to standard date

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top