Jun 17 2021 07:02 AM
need an excel macro vba code to auto calculate the "Requirement" to keep the days of stock at at least 30 days. For example, if the "days of stock" in july is >= 30 days then the "requirement" in june is 0 however if the "Days of Stock" is < 30 then the "requirement" in june should generate the material required to keep it at 30.
Attached is the file and snapshot of my code so far, any assistance would be appreciated
Jun 17 2021 10:04 AM
Returns a Variant (Date) containing a date to which a specified time interval has been added.
Returns a Variant (Long) specifying the number of time intervals between two specified dates.
Just for additional information, maybe it will help you. If not, please ignore.