Hello,
I really need some help here.
So I have a Sheet1 Column A has every individual day from a beginning date until some arbitrary date say 'Sheet1'!$A$1:$A$2000 . On the same Sheet1 I have Column B that I would like to calculate a corresponding total amount due from a list of subscribers (each subscriber has it's own row) based on a monthly payment structure on Sheet2. Sheet2 has Column A with each subscribers initial Subscription Start Date, and Column B has their Monthly payment Amount. I would also like to not include the initial payment from the subscriber, only the monthly payments after their initial starting date. This also has to take into account that some months don't have the same amount of days than other months, so if a subscriber's initial date started on march 31st 2012, then the next month's payment would have to be made on the last day april, april 30th 2012 etc. (I assume something using sumproduct and edate would work)
Thank You,
Bookmarks