View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ascottbag-hcm ascottbag-hcm is offline
external usenet poster
 
Posts: 8
Default How to count # of dates that fall between a start and end date.

Can someone help with a formula that will give a count in one worksheet of
hire dates that exist in one column of another worksheet. I have a second
worksheet (example below) that contains two criteria columns, one with month
start date, the other with month end date. I'm trying to get a count of all
dates from the first worksheet that would be =the below start date AND <=
the below end date.

START OF MONTH END OF MONTH COUNT
4/1/2009 4/30/2009