Week to Date Sales

  • Thread starter Thread starter Surf
  • Start date Start date
S

Surf

How do I calculate sales for the current week? I want to
be able to enter the week ending date(in cel b7) and
based on that, have Excel figure out what are the sales
for that week. Omitting the sales figures from the
previous week.
Example..The Sales for this week should be $550


col a col b
r1 6/1/04 $100
r2 6/2/04 $ 50
r3 6/9/04 $300
r4 6/10/04 $200
r5 6/10/04 $ 50
r6
r7 WeekEnding 6/11/04
 
Hi,

Assuming your weekending friday date is shown in B7:

=SUMPRODUCT((A1:A5-WEEKDAY(A1:A5-6)+7=B7)*B1:B5)

Regards,

Daniel M.
 
I'm getting a #VALUE message. What's wrong?
-----Original Message-----
Hi,

Assuming your weekending friday date is shown in B7:

=SUMPRODUCT((A1:A5-WEEKDAY(A1:A5-6)+7=B7)*B1:B5)

Regards,

Daniel M.




.
Click to expand...
 
Hi,
What if i needed to use a different Day of the week for the end day?
Click to expand...
You ajust the Weekday part.

General formula is :

=SUMPRODUCT((A1:A5-WEEKDAY(A1:A5-DoW)+7=B7)*B1:B5)

DoW: 1=Sunday, 2=Monday, ... , 7=Saturday

Regards,

Daniel M.
 
Thank you

Hi,

You ajust the Weekday part.

General formula is :

=SUMPRODUCT((A1:A5-WEEKDAY(A1:A5-DoW)+7=B7)*B1:B5)

DoW: 1=Sunday, 2=Monday, ... , 7=Saturday

Regards,

Daniel M.
Click to expand...
 
Back
Top