1. ## 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. ## 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.

3. ## 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

4. ## 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. ## Re: retirement calculator (2000)

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

6. ## Re: retirement calculator (2000)

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

7. ## 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>

8. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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
•