I am trying to have the EDATE formula change based on today's date.

I am using the following formula:

=TEXT(AX114,"mm")-TEXT(TODAY(),"mm")

Where AX114 is a date (01/05/2015). If I break apart the two TEXT formulae, they produce a 5 and a 6. Therefore the result should be -1.

Is there anyway of re-writing the formula above in order to produce a value of -1?

Many thanks,

Alex