Excel Forum
Similar Content
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 301: 1900 Date Problems and Fixes


See how to enter 1900 dates into cells. See how to change Regional Settings to force Excel to accept 1900 dates. See three amazing formulas to convert 1900 dates entered as text to serial number Excel dates:
1.LEFT, RIGHT, LEN, functions in one formula
2.SUBSTITUTE function
3.REPLACE (If third argument of REPLACE (num_chars) is zero, the function inserts text into a text string!)

See amazing formula solutions from the Mr Excel Message Board: barry Houdini, Andrew Poulsom





Got a Question? Ask it Here in the Forum.