Excel Formula To Sum Values Between Two Dates

In this post we will see how to add the values between two dates in excel.

Suppose we have a column in excel with numeric values in it and another column with Date values and we would like to add numeric values between two dates in excel using excel formula




Below is the data which we have sales amount in column B and Date in column A and we want to write an excel formula to sum sales amount between July 1st 2021 to Sep 30th 2021(Q3 Sales) in cell A10.

excel formula to sum the values between two dates

We will use a combination of SUMIFS function and DATE function to get the sum of values between two dates.

SUMIFS formula gives us the same of range based on some condition and DATE formula creates a date values based on the year, month and date argument that are provided to the function.

Enter the formula in cell A10 to get the sum of values of sales between two dates.

=SUMIFS(B2:B7,A2:A7,”>=”&DATE(2021,7,1),A2:A7,”<“&DATE(2021,9,30))




formula has calculated the sum between two dates in excel

Hope this helped.

Share The Knowledge

Random Posts