Thread: DATE Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default DATE Question

try this where f12 is 05115
=DATEVALUE("1/1/20"&LEFT(F12,2))+RIGHT(F12,LEN(F12)-2)-1

--
Don Guillett
SalesAid Software

"jlynn2000" wrote in message
...
I have a report that has a YRDATE format where YR=last two digits of the
year
the document was created and the DATE is the day number of that year.

For example: 05115 which should be 04/25/2005. What would my function/
formula be to convert the 05115 to the correct common date?