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
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