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.

To detect month or days or year in if formula
 

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

"ShamsulZ" wrote in message
...
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.