Forum Discussion
Solved
Date format in a criteria (need month instead of date)
Trying to get the month instead of the date as the criteria to get the sumifs in cell B4 Refer the attached file.... I have populated a database which shows the date of transaction on column B. (th...
In cell B4 you have concrete date, in particular 01 Jan 2020. What formula do is take this date and SUMIF() all data which are later than 31 Dec 2019 /EOMONTH(B4,-1)/ AND earlier or equal to 31 Jan 2020 /EOMONTH(B4,0)/.
Other words it sums all data for January 2020. If in B4 it will be 01 Feb 2020 it sums for February 2020.
If you need to sum for all Januaries, i.e. for January 2020 plus January 2021 plus etc. - that will be another formula.
Hello, to extract Month from date, kindly use, for example, =Text(A1, "mmmm").
The above will extract the full month name from the Date in column A
The above will extract the full month name from the Date in column A