Remember Me?

#1
October 17th 08, 04:16 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 13
Rule of 75 Retirement Calculation

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#2
October 17th 08, 04:42 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 2,344
Rule of 75 Retirement Calculation

Hi,

Try this

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A2,TODAY(),"Y")

in A1 enter the birthdate, in A2 the date of hire.

If this helps click the Yes button.
--
Thanks,
Shane Devenshire

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#3
October 17th 08, 05:03 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 177
Rule of 75 Retirement Calculation

I think with the person's name in column A, birthdate in column B, and hire
date in column C and row 1 containing headers, in column D row 2:

=(2*Today()-B2-C2)/365.25

gives you what you are looking for.

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#4
October 17th 08, 05:06 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
Rule of 75 Retirement Calculation

Hi,

There must be a formula bit I can't see it. Until someone comes up with one
it can be resolved with Goal seek

DOB in A1
DES in A2
Any date you want in A3
This formula in B1 =DATEDIF(\$A\$1,A3,"y")
This formula in B2 =DATEDIF(\$A\$2,A3,"y")
This formula in B3 =Sum(B1:B2)

Select B3 then
Tools|Goal seek
In the 'To value box' enter 75
In the 'By changing' box enter A3

OK and you get your retirement date in B3

Mike

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#5
October 17th 08, 05:31 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 1,240
Rule of 75 Retirement Calculation

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

Birth date in A1, hire date in A2

=(27394-(A2-A1))/2+A2

#6
October 17th 08, 05:33 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 1,240
Rule of 75 Retirement Calculation

Glenn wrote:
I need a formula to give me the date of when someone's age and years
of service equals to 75. I have the birth date and the date of hire
but have no idea where to begin. Any suggestions?

Birth date in A1, hire date in A2

=(27394-(A2-A1))/2+A2

Don't forget to format the result as a date.
#7
October 17th 08, 05:59 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 13
Rule of 75 Retirement Calculation

This gives me a date of march/1900. It should be a future date.

"ShaneDevenshire" wrote:

Hi,

Try this

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A2,TODAY(),"Y")

in A1 enter the birthdate, in A2 the date of hire.

If this helps click the Yes button.
--
Thanks,
Shane Devenshire

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#8
October 17th 08, 06:00 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 13
Rule of 75 Retirement Calculation

same deal here...This gives me a date of march/1900. It should be a future
date.

"~L" wrote:

I think with the person's name in column A, birthdate in column B, and hire
date in column C and row 1 containing headers, in column D row 2:

=(2*Today()-B2-C2)/365.25

gives you what you are looking for.

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#9
October 17th 08, 06:01 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 13
Rule of 75 Retirement Calculation

In A3, you say "put any date you want". What date am I supposed to use here?

"Mike H" wrote:

Hi,

There must be a formula bit I can't see it. Until someone comes up with one
it can be resolved with Goal seek

DOB in A1
DES in A2
Any date you want in A3
This formula in B1 =DATEDIF(\$A\$1,A3,"y")
This formula in B2 =DATEDIF(\$A\$2,A3,"y")
This formula in B3 =Sum(B1:B2)

Select B3 then
Tools|Goal seek
In the 'To value box' enter 75
In the 'By changing' box enter A3

OK and you get your retirement date in B3

Mike

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

#10
October 17th 08, 06:15 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 177
Rule of 75 Retirement Calculation

Err... I guess it would help if I did the algebra on that.

=TEXT((27393.75+B2+C2)/2,"mm/dd/yyyy")

"~L" wrote:

I think with the person's name in column A, birthdate in column B, and hire
date in column C and row 1 containing headers, in column D row 2:

=(2*Today()-B2-C2)/365.25

gives you what you are looking for.

I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Discussion (Misc queries) 0 August 25th 07 11:36 AM [email protected] Excel Discussion (Misc queries) 0 August 25th 07 11:36 AM dee29 Excel Worksheet Functions 1 April 6th 06 11:55 AM pebbles2005 Excel Worksheet Functions 1 March 31st 05 09:02 PM mschumacker Excel Worksheet Functions 2 March 13th 05 09:21 PM

All times are GMT +1. The time now is 12:18 PM.