Posted to microsoft.public.excel.worksheet.functions

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Converting Julian Dates to regular dates

You sure they are Julian dates not just Excel's 5-digit serial numbers?

See Chip Pearson's site for methods of converting.

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

Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 19:32:01 -0700, CDTucson
wrote:

I have a worksheet (inherited) that uses Julian dates in one field - I need
to display the same date in another field in conventional date format. Is
there a formula that will accomplish this? Thanks for your help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting julian dates	Dvelasq	Excel Worksheet Functions	1	October 25th 06 10:53 PM
Julian dates	nick	Excel Discussion (Misc queries)	3	May 8th 06 04:48 PM
julian dates	Lylesm	Excel Discussion (Misc queries)	5	January 5th 06 07:45 PM
Excel should have a formula for Converting Julian Dates	Yakimeshi	Excel Worksheet Functions	0	May 17th 05 06:23 PM
Excel should have a formula for Converting Julian Dates	Peo Sjoblom	Excel Worksheet Functions	0	May 17th 05 06:15 PM

All times are GMT +1. The time now is 04:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us