Thread: Is there a way to use wildcards for dates?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MildJoe MildJoe is offline
external usenet poster
  
Posts: 3
Default Is there a way to use wildcards for dates?
I want to pick out all the dates in september 2008 from a column of many
dates, and use it in a SUMIF, but an asterix or questionmark wont work like
this:
=SUMIF(G7:G8;"??.09.2008";F7:F8)
=SUMIF(G7:G8;"*.09.2008";F7:F8)


Reply With QuoteReply With Quote