Posted to microsoft.public.excel.worksheet.functions

DestinySky DestinySky is offline

external usenet poster

Posts: 16

JULIAN DATES?

I have a spreadsheet that has, what I believe are Julian Dates.

Ex: 20007088
2007090
2007092

these are in a column labled: Date YYYYDDD

Can someone tell me how to format these to MMDDYYYY ?

Thank you!!!! :o))

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 to regular dates	CDTucson	Excel Worksheet Functions	2	June 7th 07 04:20 AM
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
julian dates in Exel	danielle	Excel Worksheet Functions	1	June 23rd 05 12:39 AM

All times are GMT +1. The time now is 10:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us