Hello,
I would appreciate if anyone can help with a formula that would solve the following task.
The last purchase of a material at a particular plant was made on 11/30/2018. There were also two other previous purchases (i.e., for the same material & plant) made on 8/25/2018 and 10/5/2018. I need a formula that would provide the most recent month and year prior to the last purchase. In the case provided above, the result should show Oct-18 (the date format needs to be the same as provided "Oct-18"). Help columns are allowed if needed. Please see attachment for the same example in excel.
Feel free to ask questions if additional details are needed. Thank you in advance for all your help and support in this matter.
I would appreciate if anyone can help with a formula that would solve the following task.
The last purchase of a material at a particular plant was made on 11/30/2018. There were also two other previous purchases (i.e., for the same material & plant) made on 8/25/2018 and 10/5/2018. I need a formula that would provide the most recent month and year prior to the last purchase. In the case provided above, the result should show Oct-18 (the date format needs to be the same as provided "Oct-18"). Help columns are allowed if needed. Please see attachment for the same example in excel.
Feel free to ask questions if additional details are needed. Thank you in advance for all your help and support in this matter.