If you have the Analysis Toolpak addin installed you could use the edate
function which allows you to add months to a date. For subtracting days
and weeks just use -1 or -7 etc. So if you had 11.10.2005 in A1:
=EDATE(A1,36)-1
would return 10.10.2008.

Hope this helps
Rowan

rostroncarlyle wrote:
I would like to be able to create a formula for an Excel worksheet using a
list of dates and then subtracting one day and adding 3 years, 2 years, 2
years 3 months, 2 years 6 months and 3 years less 1 week to their respective
columns

For example, 11.10.2005 is given date
Then 10.10.2008, 10.10.2007, 10.01.008 and 03.10.2008