View Single Post
  #1   Report Post  
Robin
 
Posts: n/a
Default 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?