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

**dagindi** · 06-01-2010, 06:30 PM

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

=SUMIFS(amount_rangeFloat,date_range,">=" & curr_date,amount_rangeFloat,"<0")

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!

**Paul** · 06-01-2010, 07:05 PM

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.

**dagindi** · 06-07-2010, 08:42 AM

Paul,

Your formula worked perfect. Only problem is after I used it I realized I didnt ask the right question.

With that said I'm going to close this thread since your formula works based on my question and I'll start a new thread with the corrected question.