Week to Date Sales

[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

 

[Daniel.M]

Hi,

Assuming your weekending friday date is shown in B7:

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

Regards,

Daniel M.

 

[Surf]

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.




.

 

[Surf]

data entry typo, All is well

Thanks you

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

 

[Randall Roberts]

What if i needed to use a different Day of the week for the end day?

 

[Daniel.M]

Hi,

What if i needed to use a different Day of the week for the end day?

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.

 

[Randall Roberts]

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.