I am looking for a formula, that assiagn certain values for certain months.

for example : i want to compare the date in Cell B4, if it falls in certain
months say Jan or March, it should take "24" in cell C4 other wise "0"

Thanks inadvance.

The MONTH() function will returns an integer, 1 thru 12, representing
the month number of a date. In your example, the formula in C4 might
be
=IF(OR(MONTH(B4)=1,MONTH(B4)=3),24,0)

This formula checks the month number of the date in B4, and if it is
either January or March, returns the value 24.

Is this what you're looking for?