Help pulling data between two dates

**Caidek** · 06-10-2011, 10:46 PM

Hello all,

First post here, here goes nothing.

I am working on a spreadsheet for my work currently, and what I need basicly is a function (or already built in command) to simply get a WEEK TO DATE budget total.

Essentially I have a budget sheet with colum A = DATE and cloumn B = $$ BUDGET

I need the spreadsheet to automaticly calculate the previous SATURDAY of the week up to TODAY and display it.

Is this possible? Any ideas?

Thanks in advance!

**Haseeb Avarakkan** · 06-10-2011, 11:03 PM

Hello Caidek, Welcome to the forum!

Please attach a sample file with the expecting results.

**Caidek** · 06-10-2011, 11:13 PM

Hi Haseeb,

Heres an example of what im trying to do

(P.S. LAST STAURDAY - TODAY is from the previous saturday untill todays date)

**Haseeb Avarakkan** · 06-10-2011, 11:20 PM

Try this,

=SUMIFS(B3:B32,A3:A32,">="&TODAY()-WEEKDAY(TODAY()-7),A3:A32,"<="&TODAY())

**Caidek** · 06-10-2011, 11:25 PM

EDIT: Sorry Haseeb, I went ahead 2 days forward in time and made a tiny tweak (changed <= to <) and it seems to be working PERFECTLY!!!

I appreciate all your awesome, extremely fast assistance!

- Alan