How To: Convert integers to dates with Excel's DATE function

Convert integers to dates with Excel's DATE function

How to Convert integers to dates with Excel's DATE function

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 141st installment in their series of digital spreadsheet magic tricks, you'll learn 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.

(1) Part 1 of 2 - How to Convert integers to dates with Excel's DATE function, (2) Part 2 of 2 - How to Convert integers to dates with Excel's DATE function

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest