Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
Hello can someone please help me.
I'm exporting a report from a diffrent scource and in one section it has this "Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
On Tuesday, October 2, 2012 2:04:03 PM UTC-5, (unknown) wrote:
Hello can someone please help me. I'm exporting a report from a diffrent scource and in one section it has this "Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 Thank you For a formula look in the help index for FIND or SEARCH and incorporate into a MID function. Or use vba with INSTR function you are looking for "(" and "-" and then format as date only without time. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
I'm exporting a report from a diffrent scource and in one section it has this
"Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 With the string in A1, maybe something likethis would help: =DATEVALUE(TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",100)),FIND("(",A1)+1,80))) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
On Tuesday, October 2, 2012 12:04:03 PM UTC-7, (unknown) wrote:
Hello can someone please help me. I'm exporting a report from a diffrent scource and in one section it has this "Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 Thank you Try this, should work with both Oct 1 & Oct 12. (single & double digits days) FYI: If the day is one digit, returns the month, day, year + space after year. Otherwise month, day & just year. =MID(F14,FIND("(",F14)+2,12) Regards, Howard |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
On Tue, 02 Oct 2012 21:43:17 -0400, Ron Rosenfeld wrote:
Const sPat As String = Please note that the sPat = line needs to be all on one line, and not split as it may appear in your newsreader. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date formula Only
On Tuesday, October 2, 2012 2:04:03 PM UTC-5, (unknown) wrote:
Hello can someone please help me. I'm exporting a report from a diffrent scource and in one section it has this "Yesterday ( Oct 1, 2012 12:00:00 AM - Oct 2, 2012 12:00:00 AM )" Can anyone tell me how I can extract the First date only and paste it to a diffrent cell? In this case it would be Oct 1, 2012 or 10/1/2012 Thank you Thank you all for the help.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract date if count formula | Excel Discussion (Misc queries) | |||
Date search and date extract | Excel Programming | |||
Extract Date from Right Formula | Excel Worksheet Functions | |||
Extract a date for formula | Excel Programming | |||
extract date from the most current date | Excel Discussion (Misc queries) |