Turn Julian Date Into "Regular" Date

[Xndman]

Howdy All,
If I have julian dates for each day in a year 1 = January 1st and 365= December 31st, is there any formula that will automatically change the numbers to their respective dates? I know I can do a 365 line lookup, but are there any other options?

Thanks!!

 

[Norie]

You don't say which year but perhaps something like this.

=DATE(2006,1,A1)

 

[yee388]

That's actually pretty cool. So today is actually January 243, 2006!

 

[Xndman]

That worked great,

Thanks!!