Excel Forum
Similar Content
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Get the Integer Part of a Number in Excel
Tutorial: How to get the integer part, the whole number, from a number that has a decimal after it....
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 #141 part 1: Day Numbers to Dates


See how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date. =DATE(2008,11,1) will put the date 11/1/2008 in a cell.





Got a Question? Ask it Here in the Forum.