Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training program - calculating dates

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Calculating Dates

excel training program - Calculating Dates

ResolvedVersion Standard

Caroline has attended:
Excel Intermediate course

Calculating Dates

Can I calculate on dates prior to 1900?

RE: Calculating Dates

Hi Caroline, Thank you for your post, In answer to your question, its a big No No, Excel only calculates dates from 1/1/1900, any date entered before that is not recognised and is entered as a text. I hope that helps, best regards Pete.

TrustPilot
TrustScore 4.9 / 5       2441 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.11 secs.