Formula to add based on DAY

[rizmomin]

Hello:

Please refer to attached file.
On every Monday moring i will have inventory count and enter the numbers for Monday in column C:K.
Then i will add all purchases bewteen Tue and Sun as shown.
I need formula in cell A34:A39 which will give the dates for SUN.
Then i need formula in cell C34:K39 to give the usage for the week.
I have manually add the formula in cell C35:K36

Let me know if you have any questions.
Thanks.

Riz

[AlKey]

Not really sure if this is what you want so give this one a try
Enter C34 copy across and down

Please Login or Register  to view this content.

[rizmomin]

Hello Allkey:

Need to tweak slightly.
Please refer to attached file.
Your results shows in cell C40 down.
The result should be C34:K37

Let me know if you have any questions.
Thanks.

[avk]

Hello rizmomin,
Refer attach file. In this file using sumifs & sumif formula with criteria based on date.

[AlKey]

try this

Please Login or Register  to view this content.

[rizmomin]

Hello Allkey:

Works great...
Now i need Date @ cell A34,A35,A36,A37,A38 so that B34,B35,B36,B37,B38 is SUN

Please let me know if you have any questions.
Thanks.

Riz

[AlKey]

Enter first day of the month in cell A33
then enter formula in A34 and copy down

Please Login or Register  to view this content.

and in B34

Please Login or Register  to view this content.

[rizmomin]

Hello Alkey:

Thanks a lot...
Riz

[rizmomin]

Hello Alkey:

Please refer to attached file.
Same sheet, but now i need weekly Total for each item for week ending for dates in cell A34:A37
I have entered manually in cell C34:C36.

Let me know if you have any questions.
Thanks.

Riz

[rizmomin]

Hello avk:

Your solution works also (above #4), Thanks a lot
Riz

[bebo021999]

Try: A34
=$A$2+CHOOSE(WEEKDAY($A$2),0,6,5,4,3,2,1)
A35=A34+7
Drag down

C34:
=SUMIFS(C$2:C$32,$A$2:$A$32,"<="&$A34,$A$2:$A$32,">="&A34-6)

Drag down

[avk]

Try in "C34"

Please Login or Register  to view this content.

and copy paste right upto "K34"

In "C35"

Please Login or Register  to view this content.

and copy paste across.
Assume their is no weeklyoff.
If you need to calculate with workday or networkdays also do. But in that case you need to create list of weeklyoff
and for networkdays : To calculate the number of workdays between two dates, you can use the NETWORKDAYS function. NETWORKDAYS automatically excludes weekends, and it can optionally exclude a custom list of holidays as well.

[rizmomin]

Hello avk & bebo:

Thanks a lot, it works

Riz