changing date value to date

[Guest]

Hello,
I would be very greatful if anyone can give me a solution to my problem. My
problem is: what is the formula to convert the date vale (for example:39124)
to date ( for example: 11-Feb-07)?

 

[T. Valko]

Just format it as a date.

A1 = 39124

Select A1

Goto Format>Cells>Number tab>Date

Select the format style of your choice

If you want to have the serial number as is in one cell and then have the
date appear in another cell, then:

A1 = 39124

Formula in B1: =A1

Then format as described above

Another, but longer way:

=DATE(YEAR(A1),MONTH(A1),DAY(A1))

Biff

 

[Stan Brown]

Sat, 21 Apr 2007 22:26:01 -0700 from sadat

I would be very greatful if anyone can give me a solution to my problem. My
problem is: what is the formula to convert the date vale (for example:39124)
to date ( for example: 11-Feb-07)?

There is no formula, because there is nothing to convert.

Select Format | Cells | Date.