How can I determine the century of a date in Excel?

Robin

Posts: n/a

How can I determine the century of a date in Excel?

I have to convert a date to a Julian date to import it into JDE OneWorld.
The problem is the OneWorld also needs the century at the beginning of the
Julian number (i.e., Julian date of 05123 needs to be 105123). Anyone have a
way of determining the century?

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Using a col of Dates by day I want to determine a wk ending date.	Ken Espo	Excel Worksheet Functions	4	February 3rd 05 11:03 PM
Using a col of Dates by day I want to determine a wk ending date.	Ken Espo	Excel Worksheet Functions	1	February 3rd 05 08:09 PM
Excel formula with date constraints	Warrior Pope	Excel Discussion (Misc queries)	3	January 28th 05 03:08 PM
Formula to determine a future date based on criteria	David	Excel Worksheet Functions	2	December 15th 04 07:51 PM

All times are GMT +1. The time now is 12:22 AM.

Menu

About Us