LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default Counting problem

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Problem Becks Excel Discussion (Misc queries) 4 May 11th 06 09:38 AM
Counting Problem peter_rivera Excel Discussion (Misc queries) 1 September 16th 05 09:19 PM
counting problem LucasBuck Excel Discussion (Misc queries) 4 September 13th 05 05:18 PM
counting problem philip Excel Worksheet Functions 2 August 5th 05 12:47 AM
Counting problem again! Connie Martin Excel Worksheet Functions 2 November 2nd 04 06:14 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"