RockFish74
New Member
- Joined
- Aug 31, 2017
- Messages
- 19
Hello,
I am struggling with a function that returns a quantity (value) if the expiry date falls between today and today+180 days. I would prefer not to use IF(AND)... if possible.
For example ... today's date is 2/6/2020 and 30 units expire on 6/14/2020 (within today+180) then 30 should be returned. If the 30 units expire on 9/12/2020 (falls outside of today + 180), then return a blank. Blanks should be returned if the date is less than today.
Any assistance is greatly appreciated!
I am struggling with a function that returns a quantity (value) if the expiry date falls between today and today+180 days. I would prefer not to use IF(AND)... if possible.
For example ... today's date is 2/6/2020 and 30 units expire on 6/14/2020 (within today+180) then 30 should be returned. If the 30 units expire on 9/12/2020 (falls outside of today + 180), then return a blank. Blanks should be returned if the date is less than today.
Any assistance is greatly appreciated!