To detect month or days or year in if formula

[ShamsulZ]

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.

 

[David Biddulph]

=IF(MONTH(A1)=10,B18*2,"")