Get HR Software

Excel Age Calculator - Xls Download


Greetings, Friends, Find herewith attached excel tool. Regards,
From Saudi Arabia, Riyadh
Attached Files (Download Requires Membership)
File Type: xls Excel- Age Calculator.xls (13.5 KB, 13092 views)

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
Attached Files (Download Requires Membership)
File Type: xls Excel- Age Calculator.xls (16.0 KB, 3948 views)

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
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
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.


Saudi Arabia, Riyadh
20 December 2009 12.53.56 PM
Views: 16067 Replies: 4 Appreciations: 1
#Industrial Relations
How to form a Canteen Committee and its rules
05-04-2022 | India, Bhopal
Is there any alternative model for VRS that a manufacturing company can offer its aging union workers for an exit route?
27-04-2022 | India, Hyderabad
Suggest about the implementation Labour Code in Haryana UP & HP?
16-05-2022 | India , Bangalore
#Labour Laws
Regarding paid Medical leave of employee for one moth or more
25-06-2024 | India, Bhopal
Rolling back increment - is it fair? For the month of jan+feb the company just paid &8377;22651 citing reimbursement to be adjusted
18-07-2024 | India, New Delhi
Are apprentices countable in factory license or not?
23-07-2024 | India, New Delhi




Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.