=DATE(LEFT(E5)+2000,1,RIGHT(E5,3))

  • Thread starter Thread starter NEW USER
  • Start date Start date
N

NEW USER

THE SUBJ FORMULA WORKS (CONVERTS JD TO CALEDAR DATE).
Would appreciate if someone would tell me what the formula
is doing with the info contained in E5.

THANKS FOR THE HELP!
 
LEFT(E5)+2000

*Take the 1st character in E5 and add 2000 to get the
correct year (assume it's 3 for the example)

RIGHT(E5,3)

*Take the right 3 characters and get the day of the year
(such as the 334th day of the year)

Use the DATE function to convert all of this to an actual
date.

=DATE(YEAR,MONTH,DAY)
=DATE(2003,1,334)

which means return the 334th day of 2003, where the 1 is
January.

HTH
Jason
Atlanta, GA
 
Back
Top