PDA

View Full Version : HOW TO CALCULATE SUM BETWEEN TWO GIVEN DATES



ffarshadd
06-11-2017, 07:08 AM
I have a column in which all the cells are in date format like this: 4/29/2017. in next column i have numbers
how can i have the sum of the numbers between two specific dates that i say. for example the sum between 4/29/2017 and 3/21/2017
sometimes there's no number for 4/29/2017 or 3/21/2017 but i still need the sum between them. how can i do that?. I'll appreciate your help

YasserKhalil
06-11-2017, 07:39 AM
Hello
Have a look at this link
From Here (https://exceljet.net/formula/sum-if-date-is-between)

ffarshadd
06-11-2017, 09:09 AM
Hello
Have a look at this link
From Here (https://exceljet.net/formula/sum-if-date-is-between)

thank you very much. it was a huge help

YasserKhalil
06-11-2017, 04:11 PM
You're welcome. Glad I can offer some help for you