Excel Forum

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.