Ms Excel - Formula

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

Thread Status:
Not open for further replies.
  1. vava

    vava New Member

    Joined:
    Jun 16, 2006
    Messages:
    8
    Likes Received:
    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. tuxfan

    tuxfan New Member

    Joined:
    Feb 4, 2004
    Messages:
    2,653
    Likes Received:
    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 :D 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 Sebastian

    Keith Sebastian New Member

    Joined:
    Mar 30, 2005
    Messages:
    942
    Likes Received:
    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
Thread Status:
Not open for further replies.

Share This Page