Date value for a worksheet

M

Mac

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

Jim

=IF(MONTH(A2=11),B2+C2,"Wrong month")
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")
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
VBA Coding Help for Beginner 0
Calculate the median value before a specified list 0
If or VLookup function 0
YTD SUMIF based on current date 3
Determining the Sunday date of the third "full" weekend of a month 26
MS Project. Real progress of the project, % complete 1
Expanding Date Formula 0

Top