Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Problem | Excel Discussion (Misc queries) | |||
Counting Problem | Excel Discussion (Misc queries) | |||
counting problem | Excel Discussion (Misc queries) | |||
counting problem | Excel Worksheet Functions | |||
Counting problem again! | Excel Worksheet Functions |