Converting a Hex date to YYYYMMDD

How do i go about converting a number in Hex to a readable date.

As an example i know 57624 is 8/10/2007

Thanks

57624 decimal is 06 Oct 2057; enter it into a cell and format it as a date (Format > Cells > Number > Date) to see.

57264 interpreted as hex is 357924 decimal, which is 16 Dec 2879.

with the hex in a1
use in b1 =HEX2DEC(A1)
(enable the analysis tool pack in tools /add ins first)
and format b1 to desired date format

My mistake i was wrongly informed. This is a conversion from packed decimal to gregorian.

Any ideas.

From my info 57624 is 8/10/2007

Thanks

By "8/10/2007" I presume you mean 8th October 2007 (not 10th August) in which case that looks like a count of days from 1/1/1850. If so then with your "date" in A1 you can convert to a gregorian date with

=A1-18261

format as date

This assumes you are using Excel's default 1900 date system. The following formula does the conversion irrespective of date system (1900 or 1904)

=A1-19723+DATE(4,1,1)

Thank you for your help
this has sorted it for me

P.j.