Counting problem

[Guest]

I am trying to get an accurate number of days for uptime within my
observation range. For example, if my range is 7/1/06 - 7/31/06, I have an
observation of 30 days. My dates for the various equipment I am looking at
are for downtime. The data is in the following format. For the date range
above I only want to take into account the number of days after the last date
cleaned. Therefore, there would be 10 days of data to use 7/21 - 7/31.
Similarly if I changed my dates to 10/1 - 10/31/06 I want to ommit 10/1 -
10/5. The tricky part comes in when I want to look at 7/1/06 - 10/31/06. Here
I would only drop out dates prior to 7/21.

Date Cleaned
7/21/06
10/3/06
10/4/06
10/5/06
12/4/06
12/5/06

I don't know if this is even possible, but any suggestions would greatly
appreciated.

 

[Guest]

A correction for this problem. In the last statement I would also want to
drop 10/3, 10/4, & 10/5 for the uptime.

 

[Steve G]

I am trying to get an accurate number of days for uptime within my
observation range. For example, if my range is 7/1/06 - 7/31/06, I have an
observation of 30 days. My dates for the various equipment I am looking at
are for downtime. The data is in the following format. For the date range
above I only want to take into account the number of days after the last date
cleaned. Therefore, there would be 10 days of data to use 7/21 - 7/31.
Similarly if I changed my dates to 10/1 - 10/31/06 I want to ommit 10/1 -
10/5. The tricky part comes in when I want to look at 7/1/06 - 10/31/06. Here
I would only drop out dates prior to 7/21.

Date Cleaned
7/21/06
10/3/06
10/4/06
10/5/06
12/4/06
12/5/06

I don't know if this is even possible, but any suggestions would greatly
appreciated.

Type in the dates to a worksheet. Copy the dates to an adjacent
column and format this adjacent column as text. The number
equivalents should show in this second column. In the third column
put in a formula such as A2-A1 in the second row, A3-A2 in the in the
third row, etc.

If this is too cumbersome there are formulas for calculating the
number of days between to dates. These formulas can be obtained from
several web sites such as

http://www.cpearson.com/excel.htm

Steve G

 

[Steve G]

Type in the dates to a worksheet. Copy the dates to an adjacent
column and format this adjacent column as text. The number
equivalents should show in this second column. In the third column
put in a formula such as A2-A1 in the second row, A3-A2 in the in the
third row, etc.

If this is too cumbersome there are formulas for calculating the
number of days between to dates. These formulas can be obtained from
several web sites such as

http://www.cpearson.com/excel.htm

Steve G- Hide quoted text -

- Show quoted text -

Vito--I was careless in my message above. I should have stated B2-B1
etc. because it is column B that you are pasting the dates to in the
number equivalents by pasting as a text format. Steve G