Specific Date from a Range

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
What formula do I use to show only 03/01/2010 from data that looks like this:
03/01/2010-03/31/2010
 
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
 
Back
Top