Thread: To detect month or days or year in if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ShamsulZ ShamsulZ is offline
external usenet poster
  
Posts: 23
Default To detect month or days or year in if formula
Hi fren,

Can anybody show me how to detect particular month in if formula. E.g is in
A1 cell the data is 01/10/2006. The formula that I want to do is if the month
in cell A1 is '10', then B18*2 . Ok thanks fren.
Reply With QuoteReply With Quote