First time here? Check out the FAQ!

1 | initial version |

Probably the OQ worried about the Gregorian calendar reform. **Nearly everything will also work with older dates.**

Details:

In fact **the DATE function does not accept parameter values refering to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified foe dates before 1582 though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

2 | No.2 Revision |

Probably the OQ worried about the Gregorian calendar reform. **Nearly everything will also work with older dates.**

Details:

In fact **the DATE function does not accept parameter values refering to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified ~~foe ~~**for ****dates before 1582 1582** though it will not return an error but

3 | No.3 Revision |

Probably the OQ worried about the Gregorian calendar reform. ~~Nearly ~~*Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values refering to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

4 | No.4 Revision |

Probably the OQ worried about the Gregorian calendar reform. *Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values refering referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case.

5 | No.5 Revision |

*Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with ~~V5.2.2)~~V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000 or earlier. What a disgrace!)

6 | No.6 Revision |

*Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year ~~0000 or earlier. What a disgrace!)~~0000.)

7 | No.7 Revision |

*Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year ~~0000.)~~0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.

8 | No.8 Revision |

(This answer only is about Calc. I am not enough experienced with Base.)

*Nearly* everything will also work with older dates.

Details:

In fact **the DATE function does not accept parameter values referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.

9 | No.9 Revision |

(This answer only is about Calc. I am not enough experienced with ~~Base.) ~~Base and things may depend there on the underlying wrapped-in database engine or the one connected.)

*Nearly* everything will also work with older dates.

In fact **the DATE function does not accept parameter values referring to days earlier than 1582-10-15** the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. **The ISLEAPYEAR function** is not specified **for dates before 1582** though it will not return an error but **wronly apply the Gregorian rule** (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.