Okay, I do not have the option today in my spreadsheet, where the choice today should be on the same formulate. Is it possible?

In Open Office works as follows:

= MONTH (TODAY ();$' END DATE '. $ G $ 7, 0) and that the G7 is where is located the end date. This way the update is automatic and I do not need a field today () on a new cell.