Excel ka aik formula chahiye..Plz Help me

**umair.khokhar** · 11th July 2008, 09:41 AM

mujhe excel ka aik formula chaiye

Date of Birth Current Date Age
12-Dec-1980 11-July-2008 ?????

Main age kaise maloom karon plz help

**syed_mst** · 11th July 2008, 10:05 AM

Current date-date of birth=Age
Like
12-Dec-1980 11-Jul-2008 = 30-Jul-1927

Phir Select kain 30-Jul-1927

or Format ma ja kar Cells open karin or phir number tab ma ja kar custom per click kain or Type wali field ma ja kar ya type karin

yy" Year", mm "Month", dd "Days"

Or OK kar dain

Result
A B C D
12-Dec-1980 11-Jul-2008 = 27 Year, 07 Month, 30 Days

**umair.khokhar** · 11th July 2008, 11:23 AM

thanx bhai ab muje ye formula chahiye ke aik bande ki date of birth maloom hain aur find ye krna hai ke wo 60 years ka kb ho raha hai...

Date of Birth Reaching 60 years

11-July-1980 ???????????????

is ki date of birth 11 july 1980 hai aur ye 60 saal ka kb ho ga?????

**~*hiway*~** · 11th July 2008, 11:44 AM

Yahan check karen:

http://office.microsoft.com/training...RC061771061033

**umair.khokhar** · 11th July 2008, 02:30 PM

yahan nahin hai ...........

**umair.khokhar** · 11th July 2008, 02:32 PM

thanx bhai ab muje ye formula chahiye ke aik bande ki date of birth maloom hain aur find ye krna hai ke wo 60 years ka kb ho raha hai...

Date of Birth Reaching 60 years

11-July-1980 ???????????????

is ki date of birth 11 july 1980 hai aur ye 60 saal ka kb ho ga?????

**Sheeda_Pastol** · 12th July 2008, 03:45 AM

i assue kay aap nay cell A1 main Date of birth likhi hai

A b c d
birth date age reach 60 on reach 60 after
1 11-July-1980 =today()-A1 =A1+DATE(60,1,0) =C1-TODAY()

cell a1 aur c1 ka format date rakhain aur b1 aur d1 ka format , custom main jaakar yy" Year", mm "Month", dd "Days" kadain.

yeh result aaye ga

A b c d
birth date age reach 60 on reach 60 after
1 11-July-1980 28 Year, 1Month 1 day 11-july-2040 31 Year,12Mont,30 days

Yani aap ki current Age hai 28 year, 1 month aur 1 day aur aap 11-july-2040 ko 60 kay hongay aur 60 age honay kaly liay aap kay paas 31 yeas, 12 month aur 30 days baqi hai