Jump to navigation Jump to search
- 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 .
- JULIANDATE("8/15/2017") = 2457980.5
- JULIANDATE("10/1/2000") = 2451818.5
- JULIANDATE("3/31/1700") = 2342060.5