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?

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?

Is F12 a number or text format? When using my location for 05115 in the
formula, as a text field it gives me something other then a date.

"Don Guillett" wrote:

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?

f12 is the cell with 05115 entered as text in the cell
--
Don Guillett
SalesAid Software

"jlynn2000" wrote in message
...
Is F12 a number or text format? When using my location for 05115 in the
formula, as a text field it gives me something other then a date.

"Don Guillett" wrote:

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?

Did it give you 38467? If so, change the cell format for the result cell
from General (or Number) to Date.
--
David Biddulph

"jlynn2000" wrote in message
...
Is F12 a number or text format? When using my location for 05115 in the
formula, as a text field it gives me something other then a date.

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


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

Thank you David and Don I appreciate your assistance!! It worked and I have
converted over 19000 lines. Thanks again!

"David Biddulph" wrote:

Did it give you 38467? If so, change the cell format for the result cell
from General (or Number) to Date.
--
David Biddulph

"jlynn2000" wrote in message
...
Is F12 a number or text format? When using my location for 05115 in the
formula, as a text field it gives me something other then a date.

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


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

Glad to help.

--
Don Guillett
SalesAid Software

"jlynn2000" wrote in message
...
Thank you David and Don I appreciate your assistance!! It worked and I
have
converted over 19000 lines. Thanks again!

"David Biddulph" wrote:

Did it give you 38467? If so, change the cell format for the result cell
from General (or Number) to Date.
--
David Biddulph

"jlynn2000" wrote in message
...
Is F12 a number or text format? When using my location for 05115 in the
formula, as a text field it gives me something other then a date.

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


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