ExcelBanter - Syntax help with date calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Syntax help with date calculation (https://www.excelbanter.com/excel-worksheet-functions/173941-syntax-help-date-calculation.html)

Syntax help with date calculation

I hope to sum certain cells based on their projected due dates, but can not
figure out how to do it. I think this can be done with SUMIF. The 5
groupings I need to sum are within 30 days, 60 days, 90days , 90+ days, and
"past due"

Column H contains the close date. Column G contains the $ values.

Here's what I've done but think I am way off base.

=SUMIF(H:H,"<=Today()+30",G:G)
=SUMIF(H:H,"<=Today()+60",G:G)
=SUMIF(H:H,"<=Today()+90",G:G)
=SUMIF(H:H,"Today()+90",G:G,))
=SUMIF(H:H,"<Today()",G:G)

Thanks

Syntax help with date calculation

On Tue, 22 Jan 2008 15:58:11 -0800, Orion4MJ
wrote:

I hope to sum certain cells based on their projected due dates, but can not
figure out how to do it. I think this can be done with SUMIF. The 5
groupings I need to sum are within 30 days, 60 days, 90days , 90+ days, and
"past due"

Column H contains the close date. Column G contains the $ values.

Here's what I've done but think I am way off base.

=SUMIF(H:H,"<=Today()+30",G:G)
=SUMIF(H:H,"<=Today()+60",G:G)
=SUMIF(H:H,"<=Today()+90",G:G)
=SUMIF(H:H,"Today()+90",G:G,))
=SUMIF(H:H,"<Today()",G:G)

Thanks

You're very close:

=SUMIF(H:H,"<="&TODAY()+30,G:G)

--ron