?
Solved

On what date will someone be 60?

Posted on 2014-11-06
4
Medium Priority
?
96 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 1000 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 1000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

762 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