MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Extract Month Name From a Date?

I want to extract Month from a Date … let me explain a bit more

I have a column Date, Sex, Value ……. and I have another column Month, Male, Female, Total Value …so I want to calculate total MALE, FEMALE, TOTAL for the month.

but when I am using any function like Date, Monthname etc..all return digit like 1,2,3 .. but nothing is returning Months like January, February etc…
—–
Kailash Purohit

Comments: 6 Responses to “How Do I Extract Month Name From a Date?”

    5 months ago

    Use MONTH to get the month number. Use MONTHNAME to get the name of the month from the number. So if cell A2 holds a date, then =MONTHNAME(MONTH(A2)) will give you the name of the month.

    Kailash Purohit
    5 months ago

    Thank you very much .. this answer helped me... but after applying this I am facing new problem... when I am using MONTHNAME(MONTH(A2)) inside the CountIFs and Sumif .. it is giving an error... "requires that all range arguments are the same size." ... I actually want to count total no. of Male and Female for each month and it is from other table where we have entered date in date formate like 12 Jan 2022 ...

    5 months ago

    Kailash: Examine those formulas closely, read the help info for each function, and fix the problems. That's all I can suggest. COUNTIFS will do what you want, but you have to use it correctly.

    kailash purohit
    5 months ago

    hello I posted it on apple forum as I was not able to post images here.... so you can see screenshot and can understand what i am doing...

    https://discussions.apple.com/thread/253673798

    thank you

    5 months ago

    You have the first parameter of COUNTIFS set to MONTHNAME(MONTH(Table 1::A))) That doesn't make sense. The Month function takes a single value, not a column.

    In Table 1 you need to create a new column and use MONTHNAME(MONTH()) to put the name of the month into each row. Then you can reference that row in your COUNTIFS. The way you do the next column, GENDER, is correct. You just have to prepare a column and do the same thing for the month.

    Kailash Purohit
    5 months ago

    Thank you very very much... it worked... your always save my life :)

Leave a New Comment Related to "How Do I Extract Month Name From a Date?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)