Explanation:
My attached data (Excel Problem.xlsx) consisting 3 fields i.e. Order #, Actual Dispatch Plan and Tentative Production Plan. I am using CSE formula.
The Actual dispatch plan is being calculated on the basis of maximum date of Tentative production plan field.
Like, for Order # 203, the maximum production date is 8th October, so Actual dispatch plan is 8th Oct, likewise 188 = 12th Oct and so on .
Problem:
If there is blank of text in the Tentative Production Plan field, the Actual plan should display "Input Date", but in my case it is also showing date.
Bookmarks