MONTHIF

Question

Can anyone help me, I am wondering if there is a formual that is =MONTHIF, and if there is how this would work.

Many thanks and I look forward tp hearing from you soon.

Chris

Answer 1

I am trying to return either a Month value for a cell, eg the month number, or a blank cell to allow me to carry out the next calculation without there being a #Value in the cell which is then compremising the next step.

 

Many thanks and I look forward to hearing from you in the near future.

 

Chris

As a general way of avoiding errors you can use the IFERROR() function.

Something like this maybe:

=IFERROR(MONTH(A1),"")

This will return an empty string if the result of the MONTH() function should be an error value like #VALUE!

Hope this helps / Lars-Åke

Answer 2

I am trying to return either a Month value for a cell, eg the month number, or a blank cell to allow me to carry out the next calculation without there being a #Value in the cell which is then compremising the next step.

If you have the information in "Date" format

=month(c1)

Would give you the month of the date in C1

If the information is in "Text" format a lookup table could be created to provide the right month - but you would have to provide the "format" of the text.

Answer 3

I am trying to return either a Month value for a cell, eg the month number, or a blank cell to allow me to carry out the next calculation without there being a #Value in the cell which is then compremising the next step.

Many thanks and I look forward to hearing from you in the near future.

Chris

Answer 4

Not sure what you want to do but

=if(month(c1)=8,"August","Not August")

Answer 5

There is no such function, but I'm sure we can create either a formula or a UDF (user defined function) to do what you want once you describe to us how you would like such a function to work. Besides a written description, please include several examples so we get a good idea of the functionality you are after.

---

NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.