Date Conversion
mecca wrote:
I import a date from another program which converts the date from 12/19/2008
to 1,229,666,400. How do I get excel to convert it back?
With 1,229,666,400 in A1, put this in B1 and format it as date:
=A1-1229626599
But that might only work for this particular example. If so, maybe if you
provided a few other data points someone could figure it out.
|