"AvalancheMike" wrote in message
...
Thanks. I'm familiar with countif, but how do I incorporate countif in a
macro? I know I could have the macro write the formula on the spreadsheet
and gather the information that I need. Then I can delete the formula.
But
is there a cleaner way to do this without writing out a formula to the
spreadsheet and then deleting it?



In that case, use the DATEDIF function
http://www.cpearson.com/excel/datedif.htm

/Fredrik