Hi all,
I am trying to write a formula/macro that will figure out how many weeks are left in each month after a certain date (with a 1 week buffer) and lasting for a certain duration of time and then calculating the monthly revenue for each month.
For instance if I have a start date of 1/1/12 and a duration of 11 weeks and weekly revenue of 10,000. I would come up with 3 weeks left in Jan, 4 weeks left in Feb, and 4 weeks left in March, and 0 weeks left in April. This would give me $30,000 for Jan, $40,000 for Feb, $40,000 for March, and $0 for April.
ExcelFileHELP.xlsx
Thanks,
Mike
Bookmarks