I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.

Format Cells... Number Date anything you want
--
Gary''s Student - gsnu200721


"Daniell" wrote:

I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.

How about just formatting that cell as a nice looking date:

Format|Cells|Number tab|choose your favorite date format.

Daniell wrote:

I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.

--

Dave Peterson

To clarify responses see Chip Pearson's site on how Excel stores dates and
times.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Mon, 14 May 2007 16:19:01 -0700, Daniell
wrote:

I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.

Thanks for the help.

"Daniell" wrote:

I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.