Suhaskhambe
Executive Human Resource At Emcure Pharmaceuticals
Mayur Shinde HR
Assistant Manager - Hr
Ankitchaturvedi
Manager - Hr Excellence
Snsitaram
Agm (p&a)
Reetugour
Executive - Hr/admin
Jagu1984
Am - Hr
Prasad715
Hr -payroll, Attendance, Pf & Esi
AjayDhiman8836
Hr, Hr Executive
Hrcwpl@commanderwatertech.com
Andheri East. Hr Executive
+3 Others

Thread Started by #p.u

hi,
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.
Regards
28th January 2013 From India, Pune
Hi Pl check the attachment. it will help you to calculate completion date of probation period of an employee. Thanks
28th January 2013 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Date formula.xls (16.0 KB, 8951 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)
28th January 2013 From India, Pune
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+(364/2)
Ex:
DOJ Confirmation due date
16-Dec-09 16-Jun-10
29th January 2013 From India, Bangalore
Hi P. U., Please find attached herewith the spreadsheet with the formaula as if yoiu needed. Kindly use this file for your future use.
29th January 2013 From India, Mumbai
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.
29th January 2013 From India, Chennai
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.
30th January 2013 From India, Mumbai
This is a very good short cut for calculation. Can you please provide for retirement at the age 58 years.
31st January 2013 From India, Hyderabad
Hi, Please find attached herewith the retirement AGE calculator. it will give you the best result as you wanted. please give your feedback.
1st February 2013 From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls Retirement Age Calculator 58 years.xls (18.5 KB, 3455 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.
1st February 2013 From India, Hyderabad
Hi, Please change Date of Joining to Date of Birth in the excel column name. There was Typo error.
1st February 2013 From India, Mumbai
Hello, use this formula as =EDATE(DOJ,6). You will get the exact date of confirmation. Regards, Ranjita
1st March 2013 From India, Kolkata
#Anonymous
hi suhas,
excel file is good and useful but there is a little correction needed. since the date of birth is required to calculate the age hence the column you mention (c) date of joining should be corrected to date of birth.
this file can be used for calculating gratuity since the date of joining is mentioned.
hope you will do the needful.
well done keep it up.
regards
16th December 2013 From India, Calcutta
I would like to have the formula by what date a person will achieve 58 years D O B : 01.06.1958 BY I REQUIRE THE DATE WHEN HE WILL BE ATTAIN 58 YEARS - FORMULA FOR THIS
23rd June 2015 From India, Anantapur
suhaskhambe thanks for sharing such a nice formula for remarks. very good to see. this will help me to present to the management and will help me in recruitment planning against vacancy. thanks n gbu
10th June 2016 From India, Ambala
hi, plz help me in calculating in excel, the date of confirmation (3months) of an employee calculated from date of joining in dd//mm/yy format Regards
13th January 2017 From Pakistan, Lahore
Hi,
The best way to calculate the date and days for a new joinee is mentioned below. Please use the below mentioned formulae in excel. Whenever you open the file, the current date along with the updated days will be shown in the data. You will not need to carry out any calculations:
Name of Employee Date of Joining Date (Current) Days (Current)
XYZ 25-Jul-2016 =Today() =Today()/365
3rd May 2017 From India, Mumbai
hi M trying to find the Confirmation Date by using =+C2+(362/2) its not reflecting its Showing an Error Please help me
4th May 2017 From India, Pune
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™