Date Range and Formula identifing "X" amount of days ahead

I am using the following formula (Thanks NBVC!!) to sum up certain data in a column.

Please Login or Register  to view this content.

I wanted to change this a bit so that instead of ">=" & curr_date I only wanted to look at data 30 days out maximum (or 45 or 60)....

I tried every combo I could think of within the hash marks but everything keeps returning zero.

Where should I be putting the 30 day, 45 days, or what ever length of time i want to see from today's date.

Thanks!

Perhaps try:

=SUMIFS(amount_rangeFloat,date_range,"<="&TODAY()+30,amount_rangeFloat,"<0")

Or you could change the "curr_date" to reference the formula "=TODAY()+30" and then still use curr_date in the formula in place of TODAY()+30.