Hello all,
I have a little problem and perhaps someone could please help me? Assuming I have the values in Columns A as Start Date, B for End Date, then C for Quantity. Columns A & B is a Range per Row that gave me a Quantity in Column C.
Then, How would I get the value of Each Day Quantity?
Please see screenshot; please help with your formula to get the value of Column F-Daily Qty by Date Range.
Thank you so much in advance.
Excel1.JPG
Bookmarks