Greetings, Friends, Find herewith attached excel tool. Regards,
From Saudi Arabia, Riyadh
Acknowledge(0)
Amend(0)
78From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
Nice, but you have chosen very long formulas. It is very simple.
For example:
Date: ______ (in A2 cell), then
Age: =INT((TODAY()-A2)/365.25) will give you the same results.
Thanks for various programs on Excel. Visit [link no longer exists - removed].
From India, New Delhi
Acknowledge(0)Amend(0)
For example:
Date: ______ (in A2 cell), then
Age: =INT((TODAY()-A2)/365.25) will give you the same results.
Thanks for various programs on Excel. Visit [link no longer exists - removed].
From India, New Delhi
Acknowledge(0)Amend(0)
Great job, Rashid.
Another useful formula that will give you Age in Years, Months, and Days:
Formula:
=DATEDIF(B1, TODAY(), "y") & "." & DATEDIF(B1, TODAY(), "ym") & "." & DATEDIF(B1, TODAY(), "md")
Paste this formula in an Excel sheet in the B2 column.
Hope everyone finds it useful.
Regards,
Bhavesh
From India, Delhi
Acknowledge(0)Amend(0)
Another useful formula that will give you Age in Years, Months, and Days:
Formula:
=DATEDIF(B1, TODAY(), "y") & "." & DATEDIF(B1, TODAY(), "ym") & "." & DATEDIF(B1, TODAY(), "md")
Paste this formula in an Excel sheet in the B2 column.
Hope everyone finds it useful.
Regards,
Bhavesh
From India, Delhi
Acknowledge(0)Amend(0)
Find Following Links:
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws - In Detail
From India, New Delhi
Acknowledge(0)Amend(0)
Labour Laws and Policy
Industrial Relations & Labour Laws > Industrial Relations & Labour Laws 16
Labour Laws - In Detail
From India, New Delhi
Acknowledge(0)Amend(0)
Find following links for labour laws:
- [Labour Laws and Policy](http://www.scribd.com/doc/20416478/Labour-Laws-and-Policy)
- [Industrial Relations & Labour Laws](http://www.scribd.com/doc/6624514/Industrial-Relations-Labour-Laws-Industrial-Relations-Labour-Laws-16)
- [Labour Laws - In Detail](http://www.scribd.com/doc/19209943/Labour-Laws-In-Detail)
Please let me know if you need any further assistance.
From India, New Delhi
Acknowledge(0)Amend(0)
- [Labour Laws and Policy](http://www.scribd.com/doc/20416478/Labour-Laws-and-Policy)
- [Industrial Relations & Labour Laws](http://www.scribd.com/doc/6624514/Industrial-Relations-Labour-Laws-Industrial-Relations-Labour-Laws-16)
- [Labour Laws - In Detail](http://www.scribd.com/doc/19209943/Labour-Laws-In-Detail)
Please let me know if you need any further assistance.
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Labour laws.ppt
All the labour laws.doc
Labour Laws.pdf