date range

1. date range

So I've done some research but it all comes up bad.

Column A: random date
Column B: NOT RELATED
Column C: NOT RELATED
Column D: Number
Column G: The year number in sequence (1,2,3,4,5 etc.)
Column H: The start date for the year
Column I: End date of the year
Column J: where the results of the calculations will be.

problems: find out if the date in A1 is between the dates (H1 and I1). If it is then add the number (D1)
[attach]DATE CHECKING.xlsx[/attach]

2. Re: date range

You can use this formula in J2:

=SUMIFS(\$D\$2:\$D\$12,\$A\$2:\$A\$12,">="&H2,\$A\$2:\$A\$12,"<="&I2)

then copy down as required.

Hope this helps.

Pete

3. Re: date range

Thank you it worked as needed.
Is it possible to have it determined on two dates.

inserting a blank column in B and having the formula check if those two dates and all in between them. I attached another template to explain.
[attach]DATE CHECKING.xlsx[/attach]

4. Re: date range

Please try at K2 and copy down
=SUMIFS(E:E,A:A,">="&I2,B:B,"<="&J2)

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1