locked
SOMEONE HELP PLEASE with the Month function RRS feed

  • Question

  • So I'm using the month function and the formula I wrote is =Month(A2:A23) and I got 12 but when I use a different range like =Month(A24:A29) I get #value! can someone please help??
    Saturday, March 25, 2017 12:41 AM

All replies

  • The formula =MONTH(A4:A29), when entered in a single cell, will return the month of the date in A24, if A24 contains a date. The other cells in the range are ignored. If A24 doesn't contain a valid date, or something that Excel can interpret as a date, the formula will return #VALUE!

    So check the value of A24.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Saturday, March 25, 2017 9:36 AM
  • Hi sdfw123,

    Have you referred to Han's reply and checked if A24 contains a valid date?

    If his reply is helpful, it would be appreciated that you can help mark the useful reply as answer then other community members who have a similar problem may find the resolution more easily.

    If you still have concerns on this, please feel free to post back.

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, March 27, 2017 3:07 AM