One way:

A1: <end date
A2: =DATE(YEAR(A1),MONTH(A1)-24,DAY(A1))

In article ,
MLC wrote:

I want to create a formula that will take 'end date' of a contract, subtract
'notice date' of 24 months and the action date would be = new date. can
anyone help?