View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MaryZZZ MaryZZZ is offline
external usenet poster
 
Posts: 3
Default Comparing multiple column values

By Searching the Group, I figured out how to do all the formulas and
conditions except for the following

I want to count the rows that are within the last 6 months of today.
Column D has a date or is empty. So if TODAY() is 3/30/2007, I want to
count all the rows where D 9/30/2006.