Hello Excel Gurus,

I need help in a large set of data. MMDDYYYY

Qtr2ending_September_30

Course Name Start End Revenue recognise --- Deffer
Social Science 04/02/2013 06/18/2013 1000.00 ?? ??
Physics1 09/09/2013 11/04/2013 1000.00
Chemistry 01/06/2014 03/31/2014 1000.00
Biology 04/06/2013 03/31/2014 1000.00



Based on the end and start day I have to calculate revenue (either to recognize or deffer) Qtr ends september 30 so for example Physics should be based on only 21 days of September. I tried calculating days and then amount but it doesn't work for social science where the whole 1000 should be recognised.

Hope someone can help me out and I will pay it forward in Karma

Cheers!