Specific Date from a Range
 

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

Forget my last post, here is better question
 

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


"Jim" wrote:

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

A more though through question
 

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

"Jim" wrote:

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


"Jim" wrote:

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

A more though through question
 

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

--
Best Regards,

Luke M
"Jim" wrote in message
...
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

"Jim" wrote:

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


"Jim" wrote:

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