MAX/MIN to calculate depending on date range

[Eyeope]

Spreadsheet link here: https://we.tl/nHJdWgsgx6


I have a spreadsheet where I divide revenue depending on the start and end date, and it will divide revenue by the number of days of the order (from COLUMN S TO COLUMN JO).


It gets very heavy once I have 10,000+ orders and 750+ days.


Is there a way to structure it by month instead, so instead of Column S being 2016-11-01, Column S would be November, and Column T would be December etc.


I've attached my spreadsheet with my logic and formula: =MAX(0,MIN(S$3,$O4)-MAX(S$3,$N4)+1)*$K4/$P4


Many Thanks,


Eyeope

 

[Chrisdontm]

See if this will work for you;

https://www.dropbox.com/s/aps76qnp5u1zzjq/Copy of excel forum update test.xlsx?dl=0