Thread: Lookup dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Lookup dates
Hi

Paste this formula in Range("C1"). This will display the figures for 1st
month.

=IF(MONTH(A1)=1,B1,"")


If this post helps click Yes
---------------
Jacob Skaria
Reply With QuoteReply With Quote