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 1^st 2021 to Sep 30^th 2021(Q3 Sales) in cell A10.

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))

Hope this helped.