Taking Action Based on Day of The Week

HyCohen

New Member
Joined
Oct 7, 2013
Messages
1
Hello,

Let's say I am selling a weekly newspaper @ $1 each (retail), and I purchase 10 newspapers at the wholesale price of $0.25 each. During the 7 day week — Wednesday through Tuesday — I sold 8 newspapers, leaving me with 2 leftover papers from that week. So, when the new newspaper comes out on Wednesday I will purchase a new batch of papers to sell. However, I also want to sell the remaining 2 newspapers from the previous week at a discount.

Another example, but as a spreadsheet:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Current Week's Papers Purchased
[/TD]
[TD]No. of Current Week's Papers Sold
[/TD]
[TD]No. of Previous Week's Papers Sold
[/TD]
[TD]Total Current Week's Papers In Stock
[/TD]
[TD]Total Previous Week's Papers In Stock
[/TD]
[TD]Notes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/2
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]9
[/TD]
[TD]4
[/TD]
[TD]To start, I had 5 prev. week's papers left over.
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/3
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]7
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/4
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/5
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/6
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]Since I was down to 2 cur. week's paper's left I got 4 more = 6, but I sold 1 = 4 in stock
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/7
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/8
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/9
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]9
[/TD]
[TD]3
[/TD]
[TD]New week: purchased 10 current week's papers & sold 1 = 9 left in stock. Moved the 3 papers remaining in the current week's papers column into the prev. week's newspaper column, and lost the 1 paper that was in the prev. week's paper column.
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


How can I get Excel to move the papers that are in the current week's papers column into the past week's papers column where they will be tracked and sold at a reduced rate?

Thanks for your help!

Warmly,
Hy with Guide Dog, "Fleetwood"
 
Just Checking your "Weeks" Go Wednesday to Tuesday correct?

If so...

After Entering initial data in Row 2, Assuming the Date is in Column A, Current Week in Column E and Previous week in F.

in Cell E3 =IF(TEXT(A3,"ddd")="Wed",B3-C3,E2+B3-C3)
in Cell F3 =IF(TEXT(A3,"ddd")="Wed",E2-D3,F2-D3)
 
Upvote 0

Forum statistics

Threads
1,226,839
Messages
6,193,265
Members
453,786
Latest member
ALMALV

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top