Thank you OssieMac....I love the cell play-by-play....works beautifully!

"OssieMac" wrote:

Hi Robin,

Assuming that the date is in cell A1 then the following should do the trick.
With this formula it does not matter if Julian date has 2 or 4 digits. eg for
Sep 8 2007 the Julian date can be 07251 or 2007251. The nested formula
LEFT(A1,LEN(A1)-3) takes care of it by subtracting the 3 characters
representing the number of days from beginning of year from the total number
of characters.

=VALUE(TEXT("1/1/"&LEFT(A1,LEN(A1)-3),"mm/dd/yyyy"))+VALUE(RIGHT(A1,3))-1

You will need to format the cells with the formula to mm/dd/yy. (Or any
other valid date format that you prefer)

Regards,

OPssieMac



"robin watersong" wrote:

My data was originally in accounting system as standard date but when I have
to query database (using MicroSoft Access), the data results for dates have
been converted to julian. I cannot find my old formula to allow me to
convert julian dates back into standard date format such as mm/dd/yr. Can
anyone please help?

Thank you,
Robin