Results 1 to 13 of 13
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    retirement calculator (2000)

    I would like to create a simple retirement calculator that will calculate the number of days left until retirement but I am not sure how to go about it. Any help would be appreciated.

    Thanks

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

    Re: retirement calculator (2000)

    I have attached an extremely simplistic example.
    You can enter your date of birth and your age at retirement (in years) in the cells with a pale green background, or you can enter the date of retirement in the cell with a pale blue background. The number of days from today until retirement will be calculated automatically.
    Attached Files Attached Files

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: retirement calculator (2000)

    Hi Dale

    In A1 place the function =Now()
    In A2 place the retirement date

    In A3 type:

    =YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),
    DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)
    <=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<M ONTH(A1),DAY(A2)
    >=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<D AY(A1)),-1)))&" months,
    "&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"

    Enjoy
    Jerry

  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: retirement calculator (2000)

    A much shorter version is to use the DATEDIF function which does all that rigamarole for you:

    =DATEDIF(A2,A1,"y")&" years "&DATEDIF(A2,A1,"ym")&" months "&DATEDIF(A2,A1,"md")&" days"

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: retirement calculator (2000)

    Agreed <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

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

    Re: retirement calculator (2000)

    You were born this year? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  7. #7
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: retirement calculator (2000)

    Edited to correct my little white lie!!

    My God. That's a depressing thought... <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    Attached Images Attached Images

  8. #8
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: retirement calculator (2000)

    On this occasion Hans,I really hope that formula is wrong!!

    The more I think about it, 'retire at 65', i'm hoping!!

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

    Re: retirement calculator (2000)

    Well, at least you weren't born yesterday! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  10. #10
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: retirement calculator (2000)

    <hr>In A3 type :<hr>
    Good luck with that!! <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>

    Me thinks there's an arguement for using copy and paste here? <img src=/S/clever.gif border=0 alt=clever width=15 height=15>

  11. #11
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: retirement calculator (2000)

    Thanks, now can it be modified so I can use it for a specific job. My job requires 20 years then I can retire, I would like to put in the day I started and my ending date. Will that work with the current formula? I believe I can also edit it to convert the days to years in the next cell right?


    Thanks,
    Dale

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

    Re: retirement calculator (2000)

    You can enter the day you started in B1 and the duration (20) in B2. The worksheet will then calculate the ending date and the number of days left. (You'd probably want to modify the descriptions in A1 and A2).

    If you want to enter the start date and end date yourself and calculate the number of days in between, you can simply subtract the end date from the start date and clear the formatting for the result.

  13. #13
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: retirement calculator (2000)

    Thanks a bunch for all your help

Posting Permissions

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