Struggling with the Excel Reoder Stock Date

Enn Jay

New Member
Joined
Sep 9, 2022
Messages
1
Office Version
  1. 2021
Platform
  1. Windows
Hi Experts
I hope you are doing wonders in your life.
I am struck with the formula. I want to link the SKU code tab estimated arrival date with the Restock date. The arrival date for an SKU is different in a different row. I want to make a formula that links the SKU arrival date with the Restock date. For example, SKU 101-1015-V2 Date of OOS (Out of Stock) is 27 Dec 23. The minimum date is 1 Nov 21 and the maximum date is 14 Aug 23. As the SKU has not been ordered yet so the formula should reflect "Not ordered Yet". In a similar case if Data is available like 5 Jan 23 then it places the 5 Jan 23 in front of SKU in the Restock column.
Constraint any value less than the OOS (Out of Stock) should not be placed in Restock Date columns. For example, OOS Date < Restock Date
 

Attachments

  • Restock Date.jpeg
    Restock Date.jpeg
    41.2 KB · Views: 8
  • SKU Code.jpeg
    SKU Code.jpeg
    60.4 KB · Views: 8

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

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