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?
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:
=MATCH(I2,{"January","February","March","April","May","June","July","August","September","October","November","December"},0)
Then in Cell H23, replace the MONTH() function with $M$2 so it looks like this:
BEFORE:
=DATE($I1,MONTH($I2&1),1)
AFTER:
=DATE($I1,$M$2,1)
In Cell AB5 do the same:
BEFORE
=DATE(I$1,MONTH(I$2&" 1,"&I1),1)
AFTER:
=DATE(I$1,$M$2,1)
Thanks! it works!
Great job!