how can I use a formula like if(month(...)=month(...) than in Excel?

Question

I must put in a date and use a formula. if another another event happens in the month contained by the date, than a calculation should be performed. for example =if(23-Nov-2003 corresponds to Nov-2003 than calculate 23%*1000, if not 0). and I simply can't get it to work

Answer 1

Suppose that A1 and B1 contain the two dates which you want to compare and that your IF statement is in C1, then your formula would be:

=IF(MONTH(A1)=MONTH(B1), [value if true], [value if false])

Provided your syntax is correct and the two referenced dates are NOT text fields (check this with Show Formulae, when the cells with dates should show as numbers), then this will work. If you are entering the dates directly into the formula, then there will likely be a problem. You would need to use MONTH(DATE(...)) to convert the date to date format before MONTH can evaluate it.

Hope that helps. Contact me if you need further clarification.

Answer 2

as above, check out Excel tuition too