Solved

On what date will someone be 60?

Posted on 2014-11-06
4
94 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Outlook Free & Paid Tools
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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 will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

726 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