Hello All,

I have a spreadsheet for multiple prepaid paid services that i will need to expense over the begin/end date of the expense. I have a cell where it calculates the number of months the service will need to be expensed. What I am trying to do is create a formula to count the number of months for a specific year below that falls between the begin date(Cell) and end date (Cell)... I will then multiply the number times the actual monthly expense.

I have been doing this manually and I know this may be more complex to have automated. Any assistance would be greatly appreciated!


Original Amount 2015 2016 2017 Total Amt Begin Date End Date # of Months
9,209.00 ??????? ?????? ?????? 9,209.00 1/2/2015 7/5/2017 31