I have another problem. I have a sheet with dates in them formatted as 01/01/2005, 02/01/2005, etc. What I need to do is read the row until a date is encountered and add 1 to a counter, then check the next row to see if it contains a date, add 1, etc. continue reading until there is a cell that does not contain a date. When that happens select a range of cells correcspoding to the dates and divide the total of those cells by the counter total to get the average. Continue reading column B. I have attached a spreadsheet to illustrate. Thanks in advance for the help.