Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    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>
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

    Try:

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

    Legare Coleman

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Looking Back At Dates (2000)

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


    Steve

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

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

    John

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

    Thanks to all!

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

    Thanks, John.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

    Thanks, Legare.

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Looking Back At Dates (2000)

    Thanks, Steve.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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
  •