Warehousing and Storage Cost Calculation Question
I’m trying to figure out a formula that does this:
I want 12 columns for each month. In these columns will be calculations that adds the cost of storage based on the number of days that particular item is being stored.
The first 15 days of storage is free, then .50 afterwards. How can I have excel determine the amount each month the item is stored?
You have the “Date Received”, “Date Loaded” (if loaded), “Free Time Ends Date”, and the 12 monthly columns.
See the green columns
Do I make since?
I’m trying to figure out a formula that does this:
I want 12 columns for each month. In these columns will be calculations that adds the cost of storage based on the number of days that particular item is being stored.
The first 15 days of storage is free, then .50 afterwards. How can I have excel determine the amount each month the item is stored?
You have the “Date Received”, “Date Loaded” (if loaded), “Free Time Ends Date”, and the 12 monthly columns.
See the green columns
Do I make since?
Attachments

26.4 KB Views: 12