Assume that you have a list of dates, and you need to know how many dates are there in the current month, next month, or the previous month. In this chapter, we will see the formula to calculate them quickly. Let’s see how to count dates in the current month in Excel. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to count dates in the current month.
=COUNTIFS(rng,”>=”&EOMONTH(TODAY(),-1)+1,rng,”<“&EOMONTH(TODAY(),0)+1)
Syntax Explanations:
- EOMONTH – The EOMONTH Function returns the last day of the month after adding/subtracting a specified number of months to a date.
- COUNTIFS – In Excel, this function will help to count the number of cells that meet multiple conditions or criteria.
- TODAY – This function is useful to know the current date on your workbook. Read more on the TODAY function.
- Plus operator (+) – This symbol is used to add the values.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Dates – It represents the input date from your worksheet.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example image.
- First, we will enter the input dates in Column B.
- Now we are going to count them based on the specified month given in Column D.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Conclusion:
Hope you like this article on how to count dates in the current month in Excel. Let me know if you have any doubts regarding this article or any other article on this site.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)