Thread: Can this be done
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drose drose is offline
external usenet poster
  
Posts: 18
Default Can this be done
Hi,
The formula below looks at current month, it their a way to look at previous
month?
=MAX(IF(MONTH(A2:A11)=MONTH(NOW()),B2:B11))

Reply With QuoteReply With Quote