Thanks a ton for the formulas - I learned a lot by studying them. One thing, if I could impose on you again and, sorry, I should have mentioned: the grid is blank - there are no dates in the table/grid. Your nice formula does not work since there is nothing to match to determine true/false. The table/grid is used for user input of hours per day of vacation, ie, they enter '8' for a full day of vacation for every day in the months prior to the value in A17 and the worksheet calcs how much time they've used and how much time they have left to use. The entry date (cell A17) contains the person's hire date.

Is it possible to have the cell colored using only the cell address based on the date in cell A17? Thanks again!!!

Thanks for your help and input - using some of your examples and a lot debug, I was able to achieve the result I was looking for. It did lead to a rather large formula but appears to be working great:

=IF(MONTH($A$17)=1,0,SUM(B2:INDEX(named_range,MATC H(TEXT($A$17,"mmm"),A2:A13,0)-1,32)))+SUM(OFFSET($A$1,MATCH(TEXT($A$17,"mmm"),$A $1:$A$13, 0)-1,1,1,MATCH(DAY($A$17),$A$1:$AF$1,0)-2))

Thanks again.