Excel Formula using dates

[dz081699]

Hello,

I'm new to the forum. I am trying to develop a formula that will calculate the number of incidents in a column i.e =sum(J5:J18) but if an incident occurred more than 6 months ago I do not want it factored into the equation. Is there a formula this type of example?

Thank you
Dan Zdrodowski

[Pete_UK]

Yes, you can use SUMIFS for this. Assume you have dates in column D, then you could have:

=SUMIFS(J:J,D:D,"<="&TODAY(),D:D,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))

which will compare the dates with today's date and only include those within the last six months.

Hope this helps.

Pete

[alansidman]

Look at this link on SumIfs

http://www.techonthenet.com/excel/formulas/sumifs.php

[protonLeah]

What's in column J? Are they incident dates or some quantity per date. To count incidents only maybe:

Please Login or Register  to view this content.

[dz081699]

Thank you everyone. Pete_UK, that worked perfectly.

Dan

[Phuocam]

A little shorter ...

=SUMIFS(J:J,D:D,"<="&TODAY(),D:D,">="&EDATE(TODAY(),-6))