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