convert julian date to calendar date in excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Juan Sanchez (jsanchez_urraza_at_hotmail.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 11:39:25 -0700

Works for the current year...

If you have your Julian date on A1 then on B1:
=DATE(YEAR(TODAY()),1,0)+A1

It will return the date corresponding to that julian date
on the current year... should be the same exept for leap
years...

Cheers
Juan

>-----Original Message-----
>Does anyone know how to convert julian date to calendar
date in excel?
>.
>

Relevant Pages

  • Re: DAY Number in an Year
    ... >> FUNCTION juldate ... >> the starting point or to change Gregorian dates to Julian. ... For a one-to-one correspondence with calendar dates, ... the leap day at the end of Feb. was at the end ...
    (comp.lang.fortran)
  • Re: It it now a leap year?
    ... even showing that the rules defined for leap ... Julian or Gregorian? ... Didn't Pope Gregory fixed the calendar, ...
    (Fedora)
  • Re: dates of Chaldea and new Chaldea
    ... The Gregorian calendar has existed only since 1582 AD ... the Julian constant leap year of 180 days every 720 years ... has been the Julian calendar from 45 BC to 1582 AD ...
    (talk.origins)
  • Re: julian date in outlook 2007
    ... Open Excel and delete any additional sheets. ... Put the first day of the Julian year under Julian date. ... JDN value. ... the next 10 years that you would then put into a .hol file and then add ...
    (microsoft.public.outlook.general)
  • Re: January 1st 1 AD ?
    ... (There were no leap years in the old style calendar. ... The Julian calendar *did* have leap years, giving an average year of 365.25 days. ...
    (comp.lang.java.programmer)