excel training program - calculating dates
RH
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

excel training program - Calculating Dates

resolvedResolved · Low Priority · Version 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.


 

Excel articles

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

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

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.04 secs.