Thread: How to get less than dates if Data in another column equals data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How to get less than dates if Data in another column equals data
Try this:

=SUMPRODUCT((B1:B100<=DATE(2008,7,31))

I've assumed your dates are in B1:B100 - adjust to suit.

Hope this helps.

Pete

On Nov 16, 7:18 pm, Dan Soleau <Dan
wrote:
I have two columns. One contains general contractor names the other contains
dates from current until december of 2008. I want to create an updating
formula to count how many dates are less than or equal too 7/31/08 for each
contractor.

Reply With QuoteReply With Quote