Good morning,
I have a workbook that I am creating that would show our parts that we order on a constant monthly basis (ie, filters, grease, bearings, etc)
Each worksheet would be for a different month and would have the following column headers
Item #
Description
Qty/Month
Location
Vendor
Lead Time
Date for next order
Date Ordered
The parts should always be expected to arrive by the first business day of the month (ie, Thur. November 1st) (we don't care to take account for holidays). I would like for the auto populating area under Date of next order to account of the days of that current month, the date that the parts need to be there, the amount of lead time the parts will take to get there, and has to account for variables such as lead time can only include business calendar days.
So for example (in the October Sheet) the month of October has 31 days and there is a 2 day lead time on filters and they must arrive by Thurs. Nov. 1st, it should autopopulate to say the date of next order will be : Oct. 29th, 2012.
But (in the November Sheet) the month of November has 30 days and there is a 5 day lead time on the filters and they need to arrive on Mon. Nov. 3rd it would then autopopulate to say the date of next order will be: Nov. 23rd, 2012.
Is this possible?
Thanks in advance.
Bookmarks