Difficulties with "Year"s

[tsallee]

I have in A1 (1/1/2001). I need to subtract 3 years from this date. I also need to take into account leap years.

The actual formula set-up I need is this:

a1 b1
1/1/01 formula stating (date-3 years+1 day) = 1/2/98

Does that make sense? Any help is appreciated more than you know because I'm going crazy on this report.

 

[barry houdini]

Try

=DATE(YEAR(A1)-3,MONTH(A1),DAY(A1)+1)

or with EDATE from Analysis ToolPak

=EDATE(A1,-36)+1

 

[tsallee]

YOU ARE AMAZING!! That worked. Thank you so very much.