M
Mac
I would like to only calculate a value if the month is
november..how do I do this function?
november..how do I do this function?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=IF(MONTH(A1)=11,"do_your_thing","")
J
Jim
=IF(MONTH(A2=11),B2+C2,"Wrong month")
Where the date is in A2 and values are in B2 and C2.
Where the date is in A2 and values are in B2 and C2.
D
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")
that it doesn't evaluate to what you would see in November:
=if(month(today())=11,yourformula,"Not this month")
D
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!
checking a cell to see if it was a November date.
Sorry if I misread it and woohoo if I got it correct!