| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating earliest start and latest end dates by contract | Excel Worksheet Functions | |||
| Deadline Notice | Excel Worksheet Functions | |||
| remove virus notice | Excel Discussion (Misc queries) | |||
| MAKING A CONTRACT FROM DATA FROM A WORKSHEET | Excel Worksheet Functions | |||
| MAKING A CONTRACT FROM DATA FROM A DIFFERENT FILE | Excel Worksheet Functions | |||
Linear Mode
