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
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
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
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?????
Yahan check karen:
http://office.microsoft.com/training...RC061771061033
yahan nahin hai ...........
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?????
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
is screen shot main Red color main formula likh dia hai
Correct screen shot
Yahan bhee dekhen:
http://www.fontstuff.com/excel/exltut01.htm
Thanx brother ap ne mera masla hal kar dia hai...
Closed
Bookmarks