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
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.
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 ...
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.
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
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.
Thank you very very much... it worked... your always save my life :)