If Between Dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello,

I'm trying to make an IF formula where if the result is between 0 and 7 days the formula will return "This Week".  I'll have a column of the date the data is pulled and then a column of the reset date.  If the reset date is going to be within the next 7 days of the date pulled what formula would I use?  I tried "=IF((([@[Reset Date]]-[@[Date Pulled]])<=7),"This Week", 0)".  However it will pull back results that are less than 0 days where the reset date is in the past behind the date pulled.  I basically need the result to say "This Week" if the number of days between the date pulled and reset date is between 1 and 7. 

Thanks for your help!