Lesson#67: Count cells in Excel having values between two dates

Lesson#67: Count cells in Excel having values between two dates

Here I am having a list of dates. Now I will show how to count cells in Excel having values between two dates.

So I made here a list of months from Jan-18 to Dec-18.

Then I have put this formula, =COUNTIFS($B$1:$B$22,”>=1/1/18″,$B$1:$B$22,”<=31/1/18″)

Count cells in Excel

This formula counts the number of cells which contains values of dates between two dates I have specified in the formula.

Count cells in Excel

So I have individually put the same formula for counting the dates of every month.
=COUNTIFS($B$1:$B$22,”>=1/1/18″,$B$1:$B$22,”<=31/1/18″)
.
.
.
.
=COUNTIFS($B$1:$B$22,”>=1/12/18″,$B$1:$B$22,”<=31/12/18″)

Count cells in Excel
See also  Short Tips#0030: COUNTIF application on numbers

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*