Bill Payment Tracker

Hi there, I was trying to start using this template, but when I filled the first bill, I get errors in the columns where month formula seems not to be working.

Can you help me?

Welcome @ricardosmenezes - It seems like cells H23 and AB5 might be having trouble interpreting the string supplied in the MONTH() function. You could try the following:

In Cell M2, beside the Starting Month, you could enter the following formula to generate a number corresponding to the month:


Then in Cell H23, replace the MONTH() function with $M$2 so it looks like this:




In Cell AB5 do the same:


=DATE(I$1,MONTH(I$2&" 1,"&I1),1)


1 Like

Thanks! it works!
Great job!

1 Like