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
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.