Prev: Macro?
Next: Calculate Dates
From: Jim on
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

 | 
Pages: 1
Prev: Macro?
Next: Calculate Dates