Date value for a worksheet

[Mac]

I would like to only calculate a value if the month is
november..how do I do this function?

 

[Peo Sjoblom]

=IF(MONTH(A1)=11,"do_your_thing","")

 

[Jim]

=IF(MONTH(A2=11),B2+C2,"Wrong month")
Where the date is in A2 and values are in B2 and C2.

 

[Dave Peterson]

I don't think you can stop the calculation, but you could wrap your formula so
that it doesn't evaluate to what you would see in November:


=if(month(today())=11,yourformula,"Not this month")

 

[Dave Peterson]

I read your post as you only wanted to show the result during November--not
checking a cell to see if it was a November date.

Sorry if I misread it and woohoo if I got it correct!