Hi There,

I have two questionson the attached sample spreadsheet. The sample has some conditional formatting and validation applied.

1)In the attached sample, im trying to count(and categorize) incidents based on number of days the incidents are open(see days open column).

The categories are
count/# of Incidents open 1-30 days
# of incidents open 31-60 days
# of incidents open 61-90 days
and incidents open > 90 days

2) If I insert an entry for closed date field, I want the value in days open column to move to the cycle time coulmn. Is this possible?

FYI
Cycle Time= Date Closed - Date Reported
Days Open= Today()-Date Reported

Your suggestions are greatly appreciated,
Nate

attached what I think you are asking for