Solved

On what date will someone be 60?

Posted on 2014-11-06
4
90 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 14

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 14

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now