# Manuals/calci/JULIANDATE

JULIANDATE (GregorianDate)

• is any Gregorian date value.

## Description

• 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 .

## Examples

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

Julian Date