# SOMEONE HELP PLEASE with the Month function

• ### 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