ExcelBanter - Contract/Notice Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Contract/Notice Dates (https://www.excelbanter.com/excel-discussion-misc-queries/163483-contract-notice-dates.html)

MLC

Contract/Notice Dates

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?

--
Thanks, MLC

JE McGimpsey

Contract/Notice Dates

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?

Mike H

Contract/Notice Dates

With your contract end date in A1 and the notice period (24) in a2 try

=DATE(YEAR(A1), MONTH(A1)-A2, DAY(A1))

Mike

"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?

--
Thanks, MLC

All times are GMT +1. The time now is 02:14 AM.