We have a spreadsheet to calculate storage in weeks, We have a date in Column, a date out column. We then need to calculate on a monthly basis how many weeks an item has been in storage during a month to calculate invoicing. We are needing a formula to work out this calculation line by line..
Solved by D. H. in 20 mins