Hello,
First post, heard a lot of great things about this forum. I have a tricky situation. I'm trying to give a prorated revenue total by month for incremental postings of revenue (ex:1/11/14-1/17/14=$76,595). Obviously the amounts like the one in my example are simple, but I'm having trouble with the straddles like: 2/22/14-3/7/14=$99,977.
Now I know I could $99,977/13= 7,90.54 and multiply it by the respective days in each month. The issue is that I have hundreds of lines of data I need to do this for.
The sheet looks like
Column A: Start Date
Column B: End Date
Column C: Called in Revenue
Column D: Days
I added the following columns:
Column E: Prior Month Straddle Days-(IF("Start of month">"Start Date","Start of month"-"Start Date",0)
Column D: Next Month Straddle Days-(IF("End of month">"End Date", "End of month"-"End Date",0)
I was trying to get the pro-rated cruise days from that, but I am pretty stuck.
Can you please help?
First post, heard a lot of great things about this forum. I have a tricky situation. I'm trying to give a prorated revenue total by month for incremental postings of revenue (ex:1/11/14-1/17/14=$76,595). Obviously the amounts like the one in my example are simple, but I'm having trouble with the straddles like: 2/22/14-3/7/14=$99,977.
Now I know I could $99,977/13= 7,90.54 and multiply it by the respective days in each month. The issue is that I have hundreds of lines of data I need to do this for.
The sheet looks like
Column A: Start Date
Column B: End Date
Column C: Called in Revenue
Column D: Days
I added the following columns:
Column E: Prior Month Straddle Days-(IF("Start of month">"Start Date","Start of month"-"Start Date",0)
Column D: Next Month Straddle Days-(IF("End of month">"End Date", "End of month"-"End Date",0)
I was trying to get the pro-rated cruise days from that, but I am pretty stuck.
Can you please help?
