78
Nice But U have Choosen Very long Formulas It is very simple
Ex.
Date:______ (in A2 cell) then
Age: =int((today()-A2)/365.25) will give u same Results...
Thanks... for various program on Excel visit... <link no longer exists - removed>
From India, New Delhi
Ex.
Date:______ (in A2 cell) then
Age: =int((today()-A2)/365.25) will give u same Results...
Thanks... for various program on Excel visit... <link no longer exists - removed>
From India, New Delhi
Great job Rashid.
Another useful formula which will give u Age in Year, Month, Days.
Formula:
=DATEDIF(B1,TODAY(),"y")&"."&DATEDIF(B1,TODAY(),"y m")&"."&DATEDIF(B1,TODAY(),"md")
Paste this formula in excel sheet in B2 column.
Hope all find it useful.
Regards,
Bhavesh
From India, Delhi
Another useful formula which will give u Age in Year, Month, Days.
Formula:
=DATEDIF(B1,TODAY(),"y")&"."&DATEDIF(B1,TODAY(),"y m")&"."&DATEDIF(B1,TODAY(),"md")
Paste this formula in excel sheet in B2 column.
Hope all find it useful.
Regards,
Bhavesh
From India, Delhi
Find Following Links
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws- In Detail
From India, New Delhi
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws- In Detail
From India, New Delhi
Find Following Links for Labour Laws..
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws- In Detail
From India, New Delhi
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws- In Detail
From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls