Thread
:
DATE Question
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett