CDate

[blademaster3090]

Hi

i have a column in an excel workbook titled cdate and the values under it are 5 digits (for example,14869, 14873 all the way to 15056). I have no idea how to convert these values to a date format. it is not through simply using the date function or converting the format to date. the values might be in stata format. could someone please help convert these values to dates?


much appreciated

[Richard Buttrey]

Hi, and welcome to the forum.
Assuming they are stata dates based on 1/1/1960 = 0 then
=A1+7047

Format the resultant number as a date.

[blademaster3090]

thanks for the reply, but these dates correspond to prices of electronics at online retaliers, so they cannot be in the 1960's. do u know any other way to get the solution?

[daddylonglegs]

for example,14869, 14873 all the way to 15056

Do you know which dates those examples represent exactly?

=A1+7047

Why 7047 Richard? In Excel 1/1/1960 = 21916 so wouldn't you need to add that value?

[blademaster3090]

hese dates correspond to prices of electronics at online retaliers

[daddylonglegs]

Yes, but do you know exactly which date 14869 represents? If you don't it's going to be difficult for anybody here to reliably convert your numbers....or for you to check that any method suggested is accurate.......

[blademaster3090]

ur right, its supposed to start from 2000, thanks for the help.

[Richard Buttrey]

Hi ddl,

Thanks for the correction, you are quite right. I'd used the 14869 number the OP first mentioned as the base date. No don't ask.

So to clarify, on the basis that the stata dates are all 1/1/1960 zero based the required formula is indeed

=A1+21916

Thanks.