Solved

On what date will someone be 60?

Posted on 2014-11-06
4
92 Views
Last Modified: 2014-11-06
Hi,

I have a list birthdays for employees in one column. In a new column, I want to calculate, when will these people be 60 years and six months.

Thanks,

San.
0
Comment
Question by:sanjay-gandhi
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
DrTribos earned 250 total points
ID: 40427639
Try this formula,  =DATE(YEAR(A1)+60, MONTH(A1)+6,DAY(A1))

Assumes the date is in cell A1 - works with XL 2010

Cheers,
0
 
LVL 15

Assisted Solution

by:Haris Djulic
Haris Djulic earned 250 total points
ID: 40427640
Hello,

you can use this formula: =+DATE(YEAR(A2)+B2;MONTH(A2);DAY(A2)), where in A2 is the birthday and in B2 is years to add ( in this case 60).

Example is shown on the attached image.
Capture.PNG
0
 

Author Closing Comment

by:sanjay-gandhi
ID: 40427732
Wow.

Works great.
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 40427761
You're welcome,
Happy days :-)
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My experience with Windows 10 over a one year period and suggestions for smooth operation
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question