Age Query

Ashu K

unread,

Aug 28, 2015, 7:13:03 AM8/28/15

to Excel VBA Lab

Dear Seniors,

Raw data is attached. want to know the date, when the employee was completed 60 yrs from the DOB.

Thanks & Regards

Ashu Kenith

Age Query.xlsx

Ashish Bhalara

unread,

Aug 28, 2015, 8:29:15 AM8/28/15

to Excel VBA Lab

Hi, use below formula.

=DATE(YEAR(I2)+60,MONTH(I2),DAY(I2))

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/fc6d600a-32de-4b17-a3df-c929b95e1e95%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ashu K

unread,

Aug 28, 2015, 8:45:43 AM8/28/15

to Excel VBA Lab, excel...@googlegroups.com

Dear Ashish Bhalara Sir,

Thank you. Formula is working perfect.

Pratibha Sharma

unread,

Aug 28, 2015, 8:55:23 AM8/28/15

to Excel VBA Lab

Hi Ashish,

Perfect Solution :)

Rgds

PS

Reply all

Reply to author

Forward