Pages

Search

Excel Help Forum - Excel General: [SOLVED] Looking to calculate months

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] Looking to calculate months
Hello, I have a simple spreadsheet that will calculate rental payments based on any given month for 1 month. I'm looking for help that will calculate based on 2 or more payments. I'm using this to calculate 1 month - =IF(C2="","",(DATE(YEAR(C2),MONTH(C2)+1,0))) C2 would equal the 1st day of...