DATE Question
 

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?

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?

DATE Question
 

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?

DATE Question
 

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?

DATE Question
 

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?

DATE Question
 

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?

DATE Question
 

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?