Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

On what date will someone be 60?

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
sanjay-gandhi
Asked:
sanjay-gandhi
  • 2
2 Solutions
 
DrTribosCommented:
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
 
Haris DjulicCommented:
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
 
sanjay-gandhiAuthor Commented:
Wow.

Works great.
0
 
DrTribosCommented:
You're welcome,
Happy days :-)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now