What you posted is a formula, isn't it? Here's some info

http://www.cpearson.com/excel/jdates.htm


Regards,

Peo Sjoblom

"Yakimeshi" wrote:

> I would like to have a formula or an easy way to convert from Julian Dates
> into normal gregorian dates. And backwards, instead of this:
>
> =TEXT(A2,"yy")&TEXT((A2-DATEVALUE("1/1/"&TEXT(A2,"yy"))+1),"000")
>
>
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions