# Converting a date serial number to a real date

**URL:** <https://forum.kirupa.com/t/converting-a-date-serial-number-to-a-real-date/274570>\
**Category:** flash\
**Created:** [October 31, 2008, 4:26pm UTC](https://forum.kirupa.com/t/converting-a-date-serial-number-to-a-real-date/274570 "2008-10-31T16:26:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![leraptor](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/leraptor/32/2353_2.png) [@leraptor](https://forum.kirupa.com/u/leraptor)\
**Post date:** [October 31, 2008, 4:26pm UTC](https://forum.kirupa.com/t/converting-a-date-serial-number-to-a-real-date/274570/1 "2008-10-31T16:26:30Z")

</div>

I’m reading dates from Excel and I get this type of serial number : 37477. It’s actually the number of days since 1-1-1900. Is there a function to convert that directly into a date in Flash ?  
Thanks,