Julian date converter

Discussion in 'Beer Talk' started by randeezy74, Aug 3, 2014.

Thread Status:
Not open for further replies.
  1. randeezy74

    randeezy74 Initiate (0) Jun 30, 2013 Colorado

    I don't know if anybody will give a crap about this but I made a little Excel document that spits out the bottling date if you put in the Julian number & year. I couldn't find a dedicated converter online and I know they're fairly easy to estimate but I'm an engineer and I like having things like this. May be more trouble than its worth but now I can easily figure out exactly how fresh that bottle of Hop Stoopid I just bought was (almost 3 months, oh well).

    https://dl.dropboxusercontent.com/u/9995742/JulianDate.xlsx
     
    utopiajane likes this.
  2. TheBeer

    TheBeer Initiate (0) Dec 19, 2013 Wisconsin

    I would hope anyone on this site is capable of computing that equation.
     
    fredmugs likes this.
  3. superspak

    superspak Grand High Pooh-Bah (10,927) May 5, 2010 North Carolina
    Society Pooh-Bah Trader

  4. fredmugs

    fredmugs Initiate (0) Aug 11, 2012 Indiana

    Keep hope alive.
     
    russpowell likes this.
  5. jesskidden

    jesskidden Grand Pooh-Bah (3,145) Aug 10, 2005 New Jersey
    Society Pooh-Bah Trader

    Theniz likes this.
  6. dedbeer

    dedbeer Pundit (767) Jun 23, 2013 Illinois

  7. dortenzio1991

    dortenzio1991 Crusader (486) Aug 12, 2011 Connecticut

    I just say that a month on average has 30 days and do very basic math to come up with the answer. I dont need an exact date to enjoy my brew
     
    PaulQuinn, dar482 and BrettHead like this.
  8. utopiajane

    utopiajane Grand Pooh-Bah (3,982) Jun 11, 2013 New York
    Pooh-Bah

    Just count by threes. So in July or August a beer that has a julian day of 175 is perfectly fine to buy .
     
Thread Status:
Not open for further replies.