Hi,

I am using excel 2000 and am not sure how to ask this question. We do
hospital vists monthly and have a quota each month to meet. For example:

Hosp Frequency May June July
1 biweekly 1, 15, 27 4, 19 7
2 quarterly 12

There is a whole list of hospitals. I want to insert a formula in the month
cells to see if the frequency is met each month (%) by having it calculated
automatically as data is entered. So I am assuming I have to hide a number
under the biweekly word, i.e. 2, to figure out a formula in each month cell
and somehow convert the day of the month to = 1 each time a date is entered
in the month. I would need to do this quarterly, annually and daily
depending on the requirement for each hospital. Does anyone know if this can
be done and how to do it? We want to retain the dates of the visits. If more
clarification is needed on what I am asking feel free to email me. I am not
sure I am explaining this clearly. Also, is there a way to change the color
of the cell automatically when the quota is met? Thanks so much.