JITENDRAPATEL
27
Asst Teacher

Dear Friends, Open attachment and calculate employee age simply Jitendra Patel Gujarat
From India, Mahesana

Attached Files
File Type: xls age calculation calculator.xls (25.0 KB, 10480 views)

Really Nice Calculator....
May i have the same calculation method to estimate employee's No.of Hours worked per day, if we capture it in excel.
Because we put time-in and time-out for Morning and Afternoon sessions.
If so, it would be helpful for us..
Thank you....

From India, Tirupati
Dear Jitendra,
Very nice work done. Its very useful.
But at the same time you must inform to all citehr members that the format of date is mm/dd/yyyy and not dd/mm/yyyy.
Initially I also faced the same problem when I entered in dd/mm/yyyy.
Regards,
MS

From Saudi Arabia, Riyadh
statemancontact Industrial and lebour Relations/ HR Management
This is awesome,but would welcome a worksheet with the possiblity of containing more than 500 staff info. with age calculation determinant opprtunity in a giffy.
From Nigeria
Good Morning Jitendra It is nice calculator. One additional message to all viewers should have been added in your post viz/ Date format is MM/DD/YYYY Thank You Chandrakant
From India, Mumbai
Dear Jitendrabhai,
Thank you for sharing such a wonderful thing with us. Much appreciated.
Dear CiteHR members,
The problem few of us are facing is with the "Date Format". Actually the format of the date is not something that can be mentioned.
Our system catches the date format on the way how we have set it in our control panel of our computer.
I have my default date format set as DD/MM/YYYY, hence this format worked for me as opposed to MM/DD/YYYY. I get error if I mention the later format.
Hope the format of the date is no longer a confusion for all of us. :)

From India, Mumbai
hi, jitendra does not open in correnct excell sheetDear Friends, Open attachment and calculate employee age simply Jitendra Patel Gujarat
From India, New Delhi
Hi Jetendra, Nice one. could you assist with unprotecting the sheet or any other way of copying the columns as it is not getting copied. Regards, Abhijit
From India, New Delhi
Dear Members,
I would like to reveal the formula for this employee age calculation sheet to create by your won
=DATEDIF(B9,C9,"Y")&"Years" & DATEDIF(B9,C9,"YM")&"Months"& DATEDIF(B9,C9,"MD")&"Days"
B9,C9 indicates the columnrow
gkupdate

From United Arab Emirates, Dubai
Dear Mr. Jiten, You have done a very wonderful job. Very easy to find actual age. If you given the codes or formula, it will be much helpful to all. Regards. V. Ganesan
From India, Madras

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™