How do I convert the serial number of a date to an Excel Date?

 

The quickest way is to select the column with dates and press CTRL + #. Alternative way is to select the cells to convert and to press CTRL + 1 and then select Date as the format.

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017