From ZCubes Wiki
Jump to navigation Jump to search
JULIANDATE (GregorianDate)

  • is any Gregorian date value.


  • This function used to convert the Gregorian date in to Julian date format.
  • In , is any gregorian date.
  • A Julian date or day number is the number of elapsed days since the beginning of a cycle of 7,980 years.
  • The starting point for the first Julian cycle began on January 1, 4713 B.C.
  • Julian dates are widely used as time variables .It is assumed that 7-day weeks have formed an uninterrupted sequence since ancient times.
  • Thus, the day of the week can be obtained from the remainder of the division of the Julian date by 7.
  • A Julian date or day number for a certain time of day on January 9, 2001, looked like this 2451919.3423000001348555

meaning 2,451,919 elapsed days since the beginning of the Julian cycle.

  • So this function is converting Gregorian date in to Julian date.
  • We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
  • We can use Range values also. For Example: JULIANDATE(#8/15/2017-12/15/2017).
  • #date notation needs mm/dd/yy format .


  1. JULIANDATE("8/15/2017") = 2457980.5
  2. JULIANDATE("10/1/2000") = 2451818.5
  3. JULIANDATE("3/31/1700") = 2342060.5

Related Videos

Julian Date

See Also