**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need help with getting a sum for a specific range of dates

Solved by X. W. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
29/11/2017 - 05:50

Welcome, Thanks for choosing Got It Pro-Excel

Excelchat Expert
29/11/2017 - 05:50

How may I help you today?

User
29/11/2017 - 05:50

hi I am trying to calculate the total number of dates between a range in google sheets

Excelchat Expert
29/11/2017 - 05:51

can you please give me an example

User
29/11/2017 - 05:52

So Row G has dates from 5/1/2014 to 11/1/2017 and I need to figure out how many times the dates for each month repeat. For example: How many people subscribed for the month of May 10

User
29/11/2017 - 05:52

2014*

Excelchat Expert
29/11/2017 - 05:52

give me one moment please

User
29/11/2017 - 05:52

thank you

Excelchat Expert
29/11/2017 - 05:58

I am working on that please be online

User
29/11/2017 - 05:59

So for example I need to look up between certain dates : 5/1/2014 and 6/1/2014 and get a sum of how many dates are in that range

Excelchat Expert
29/11/2017 - 06:00

Sure you can use countifs function for that

Excelchat Expert
29/11/2017 - 06:01

=COUNTIFS(G1:G948,">=5/1/2014",G1:G948,"<=5/31/2014")

Excelchat Expert
29/11/2017 - 06:01

I have mentioned random range G1:G948

Excelchat Expert
29/11/2017 - 06:01

you can change that as per your requirement

User
29/11/2017 - 06:02

Thank you! It works!

Excelchat Expert
29/11/2017 - 06:02

your welcome :)

Excelchat Expert
29/11/2017 - 06:02

If you have any more issues, please don’t hesitate to let us know. Have a great day!

User
29/11/2017 - 06:02

Wow! Thank you this was very helpful! You do the same

Excelchat Expert
29/11/2017 - 06:03

Thanks for choosing Got It Pro-Excel

Excelchat Expert
29/11/2017 - 06:03

bye for now

Excelchat Expert
29/11/2017 - 06:03

take care :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*