# Ms Excel - Formula

Discussion in 'Software Q&A' started by vava, Jun 18, 2006.

Tags:
Not open for further replies.
1. ### vavaNew Member

Joined:
Jun 16, 2006
Messages:
8
0
Trophy Points:
0
To prepare an employee payroll, I am putting the date of birth of a person/employee in one cell. I want MS Excel to give me the dte of retirement of the employee in the next cell. (The date of retirement is the last date of the month in which he attains 55 years of age. What formula should I use?

2. ### tuxfanNew Member

Joined:
Feb 4, 2004
Messages:
2,653
9
Trophy Points:
0
Location:
Mumbai
I could have given you the exact solution, but I don't have excel in my machine. It has no pirated softwares I use OpenOffice.org. Secondly I am too lazy to work for you . Self help is the best help

Anyway, why don't you have a look at all the date functions? If you are not too comfortable using a long function/formula, you can break it down in different columns and hide the intermediary columns!

Last edited: Jun 18, 2006
3. ### Keith SebastianNew Member

Joined:
Mar 30, 2005
Messages:
942
0
Trophy Points:
0
Location:
Doha, Qatar
Your problem is simply solved using the "=DATE" function in excel.

Let me assume you have input your employee X's birth date in cell A1. I'll assume you have used the format YEAR,MONTH,DATE.

To get the retirement date in any cell, try this formula -

=DATE(YEAR(A1)+55,MONTH(A1),DAY(A1))

I'm amazed at all the cool stuff that can be done with excel. Everyday I keep discovering new excel formulae and tricks from our lovely secretaries who also happen to be excel experts.

Cheers,
Keith

Edit: BTW, formatting of the date does not matter. You can set any format of date for both the cells and they don't even have to be similar.

Last edited: Jun 18, 2006