Menu

DATE Question

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

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?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel date scheduling not msProject	4pinoy	Excel Worksheet Functions	0	November 11th 06 08:33 PM
Date formulas	DRondeau	Excel Discussion (Misc queries)	7	September 6th 06 09:53 PM
How to return a value between date ranges	Mary-Lou	Excel Worksheet Functions	7	May 26th 06 10:00 PM
Date Question	nastech	Excel Discussion (Misc queries)	5	January 19th 06 09:40 PM
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM

All times are GMT +1. The time now is 06:36 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement