Specific Date from a Range

[Jim]

Hello,

I have a spreadsheet that has a column of dates that look like this:

Activity Dates
2/15/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
2/28/2010
2/28/2010
2/28/2010
2/28/2010
2/28/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
2/1/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
03/01/2010-03/31/2010
2/25/2010
03/01/2010-03/31/2010

I'm currently using this formula to pull the data into another sheet
(=IF(Input_Sheet!Q5=""," ",Input_Sheet!Q5)).

My question: Is there a formula I canuse that will keep the specifi dates in
this column ( for example 2/25/2010) yet calculate a specific date from the
range cell.
While calculating a mid range for the date that appear in a range, turning
03/01/2010-03/31/2010 into 03/15/2010. As well as make the formula flexable
enough to read each month of the year (04/01/2010-04/31/2010) into April 15,
2010, etc...

I hopr this is clear and thanks for the help.
Jim

 

[Jim]

What formula do I use to show only 03/01/2010 from data that looks like this:
03/01/2010-03/31/2010

 

[Jim]

What formula do I use to trim a date from a date range when some of hte cells
have a date I do nto want to trim?

See my first post for an example.

Thank you

 

[Luke M]

How about:
=IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10)))