Hello! This is my first post...REALLY hope someone can help because I am completely stuck. I've attached a workbook. The issue is on the last tab ("Summary") in column D. I am trying to find a formula that will calculate the "months since last shipment". My shipment data is on the first tab and the pivot (from where I'm trying to get the "months since last shipment") is the second tab.
So just to make sure I'm being clear, here is an example:
I want to know how many months it's been since ABC Company has had a shipment. According to my pivot, the last was in April so I need "2" to populate on my summary tab.
**Just FYI - this is a report with data up until June only, so June is my "current month" for the purpose of this excel. you can see in Z1 (on No. Shpmt tab) I have my current month identified.
There is a formula in there currently (on summary page) that a colleague helped me create. It's obviously VERY wrong but I'm not sure why and if it's even the right direction to go in.
Months since last shipment help.xlsx
Please let me know if anyone can help! I'm completely lost.
Bookmarks