# Thread: Looking Back At Dates (2000)

1. ## Looking Back At Dates (2000)

Anyone know of a formula that would give the beginning date if the ending date and number of years is given? For example, if in A1 I have the date 1/1/1998, and in cell A2 I have the number 20 that is meant to represent 20 years. What I would like to put in cell A3 is a formula that would compute the beginning date 20 years earlier than 1/1/1998. Ideas?
Thanks.

2. ## Re: Looking Back At Dates (2000)

Where cell B1 contains the number of years difference, does this do what you want?

<table border=1><td></td><td align=center>A</td><td align=center>B</td><td align=center>C</td><td align=center>1</td><td align=right>1/1/2000</td><td align=right>20</td><td align=right>=DATE(YEAR(A1)-B1,MONTH(A1),DAY(A1))</td></table>

3. ## Re: Looking Back At Dates (2000)

Try:

<pre>=DATE(YEAR(A1)-A2,MONTH(A1),DAY(A1))
</pre>

4. ## Re: Looking Back At Dates (2000)

<pre>=DATE(YEAR(A1)-A2,MONTH(A1),DAY(A1))</pre>

Steve

5. ## Re: Looking Back At Dates (2000)

In cell A3 try this: =DATE(YEAR(A1)-A2,MONTH(A1),DAY(A1))

John

6. ## Re: Looking Back At Dates (2000)

Thanks to all!

7. ## Re: Looking Back At Dates (2000)

Thanks, John.

8. ## Re: Looking Back At Dates (2000)

Thanks, Legare.

9. ## Re: Looking Back At Dates (2000)

Thanks, Steve.

10. ## Re: Looking Back At Dates (2000)

Jeff,

It is very nice of you to thank the people who helped you. That is appreciated!

But it is not necessary to create individual replies to each; you can thank everyone (by name, if you like) in one reply- see <!rule=07>Rule 07<!/rule>. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•