I've setup a weekly scenario tool that shows your starting and ending weekly inventory with the line items being the key factors like Forecast, Sales Orders, Purchase Orders, Planned Orders, etc... I export this data from SAP. I'm basically trying to recreate the planning book because our company doesn't really need it.
However, I have been told to recreate the Alert Monitoring functions in SAP. One of the basic calculations I've done is Weeks of Inventory On Hand. Anytime it gets below 1 weeks I have a Boolean. What I want to do is have a formula that essentially says if TRUE display the week starting date. The problem is IF statements can't display dates as an output.
This isn't an issue in excel so I'm confused as to why it is here.