I suggest putting the start date and end date [cell formula can be
=today()], and using countif:
http://www.officearticles.com/excel/...ft_excel.h tm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Kaye" wrote in message
...
I have a column of dates. I want to count the number of dates that are six
months or less from today. Any help would be appreciated.
kaye