Executive Human Resource At Emcure Pharmaceuticals
Mayur Shinde HR
Assistant Manager - Hr
Manager - Hr Excellence
Agm (p&a)
Executive - Hr/admin
Am - Hr
Hr -payroll, Attendance, Pf & Esi
Hr, Hr Executive
Andheri East. Hr Executive
+3 Others

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
plz help me in calculating in excel, the date of confirmation (6months) of an employee calculated from date of joining in yy/mm/dd format which must be updating regularly as per the system clock.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi Pl check the attachment. it will help you to calculate completion date of probation period of an employee. Thanks

Attached Files
Membership is required for download. Create An Account First
File Type: xls Date formula.xls (16.0 KB, 9263 views)

hi, The above said formula in the sheet is correct. Also instead you can use as below: =C2+180 This will give exact date of confirmation after 6 months (180 days of service)
Hope, Your Company has 6 months probation for all new members. in that case you can use the following formula for calculating exact Confirmation date.
DOJ Confirmation due date
16-Dec-09 16-Jun-10
Hi P. U., Please find attached herewith the spreadsheet with the formaula as if yoiu needed. Kindly use this file for your future use.
Hi Suhaskhambe, Thanks for the formular, I find this very useful. I have been responsible for working on confirmation of our employees and this formular will sure make working more easy. Thank you.
Hi Idy_O, Thanks for your reply. I hope this formula will be useful to other HR people also. please let me know if any additional help is required in this regard.
This is a very good short cut for calculation. Can you please provide for retirement at the age 58 years.
Hi, Please find attached herewith the retirement AGE calculator. it will give you the best result as you wanted. please give your feedback.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Retirement Age Calculator 58 years.xls (18.5 KB, 3568 views)

Thanks a lot. It is very useful to work on this kind of date calculations in excel. I think some one in the forum may share some more short cuts which are useful in our activities like gratuity period calculation etc.
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™