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