Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
I have a cell ("A30") on a temporary sheet that contains:
Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
Hi,
Maybe this =DATEVALUE(TRIM(MID(A30,FIND(":",A30)+1,255))) Mike "Jason" wrote: I have a cell ("A30") on a temporary sheet that contains: Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
Hi,
I forgot I was in the 'programming' group mydate = DateValue(Trim(Mid(Range("A30"), WorksheetFunction.Find(":", Range("A30")) + 1, 255))) Mike "Mike H" wrote: Hi, Maybe this =DATEVALUE(TRIM(MID(A30,FIND(":",A30)+1,255))) Mike "Jason" wrote: I have a cell ("A30") on a temporary sheet that contains: Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
Will your text part *always* be "Release Date: "? If so,
=MID(A30,15,10) -- Rick (MVP - Excel) "Jason" wrote in message ... I have a cell ("A30") on a temporary sheet that contains: Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
With the text/Date in A1 you can use something like this =MID(A1,FIND(":",A1,1)+1,255) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jason" wrote in message ... I have a cell ("A30") on a temporary sheet that contains: Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
Or, in VB code...
DateAtEndOfText = Mid(Range("A30").Value, 15) -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... Will your text part *always* be "Release Date: "? If so, =MID(A30,15,10) -- Rick (MVP - Excel) "Jason" wrote in message ... I have a cell ("A30") on a temporary sheet that contains: Release Date: 7/30/2009 I want to pull the date from this cell. I've looked at the Right function but the problem is that the date can obviously grow or shrink because it is apparently in the m/d/yyyy format. I've also looked at Find but cant seem to get the right syntax. Any suggestions would be greatly appreciated! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull date from cell with text also
Thanks!
The VB codes from Mike and Rick both did the trick, as did Ron's once I converted it to VB. The different solutions definitely helped me in general, since I am still a newbie! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull text from cell with if statement | Excel Discussion (Misc queries) | |||
Need formulas to pull date and time from 1 cell to 2 | Excel Worksheet Functions | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Pull and store a value on specific date in another cell | Excel Worksheet Functions | |||
Pull-down text in a cell | Excel Worksheet Functions |