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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Barb R." <BarbR@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 27 May 2005 09:00:02 -0700

You could get the year using the formula YEAR( ) and parse out what you need,
I suppose.

"Robin" wrote:

> 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?
.

References:
- How can I determine the century of a date in Excel?
  - From: Robin

Prev by Date: Re: HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10
Next by Date: RE: MS Query grouping
Previous by thread: RE: How can I determine the century of a date in Excel?
Next by thread: Re: How can I determine the century of a date in Excel?
Index(es):
- Date
- Thread

Relevant Pages

RE: How can I determine the century of a date in Excel?
... "Robin" wrote: ... > I have to convert a date to a Julian date to import it into JDE OneWorld. ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: search.pl
... Robin wrote: ... > performing the way I want them too, they are supposed to go through all of ... Your script passes the directory to parse(), ... would make this bug ...
(comp.lang.perl.misc)
Re: search.pl
... > Robin wrote: ... >> performing the way I want them too, they are supposed to go through all ... > parse() is using it. ... > You should be using more helpful error messages. ...
(comp.lang.perl.misc)
Re: search.pl
... Robin wrote: ... >> Your script passes the directory to parse, ... >> parse() is using it. ... there to help you find your bugs. ...
(comp.lang.perl.misc)