Posted to microsoft.public.excel.misc

Lylesm

Posts: n/a

julian dates

I am trying to covert Julian dates to calendar date and am using the formula
=DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
shows up as 1900. I don't have any of the transition boxes checked and I
formated the cell using custom d-mmm-yy. Any suggestions ?

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
Formula for calc diff between two julian dates	saltrm	Excel Discussion (Misc queries)	1	November 7th 05 08:00 PM
Dates from Julian calendar	y_not	Excel Discussion (Misc queries)	1	October 24th 05 06:36 PM
julian dates in Exel	danielle	Excel Worksheet Functions	1	June 23rd 05 12:39 AM
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 11:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us