Thread: date range additions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ND Pard ND Pard is offline
external usenet poster
  
Posts: 73
Default date range additions
In lieu of the 5/18/2008, use the Date(2008,5,18) function, etc.

Good Luck.

"Ann" wrote:

close...i need to put in a date, rather than -7. for example i need it to be
=SUMPRODUCT(--(A1:A30="a"),--(B1:B30=5/18/2008),--(B1:B30<=5/22/2008),C1:C30)

what's the correct syntax for the dates?

Reply With QuoteReply With Quote