Not sure what you're asking.

For 3-Jul you have 2 full days. For 10-Jul you 1 full day and 1 half day.

???

--
Biff
Microsoft Excel MVP


"bmac" wrote in message
...
Below is my spreadsheet. It tracks the Service Availability of an Agency.
My
question is this.. What function would I use to capture Service Agency
Availability - if I wanted to identify Y=Yes, P=Partial. Yes for full
days,
Partial is for 1/2 days. Would it be Count? Match? Index? The Area is
used
in another report using the # of days.

Agency Area Timeline type Days
X B 3-Jul Accept 1
X C 3-Jul Accept 1
X C 4-Jul Close 1
X B 4-Jul Accept 1
X C 5-Jul Ref by Ref 1
X B 5-Jul Ref by Ref 1
X B 10-Jul Ref by Ref 1
X C 10-Jul Ref by Ref 0.5
X B 11-Jul Close 1
X C 11-Jul Close 0.5



VON Accept Ref by Ref Close
3-Jul
4-Jul
5-Jul
10-Jul
11-Jul


thanks for any ideas you can share twith me
--
bmac