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
From India, Pune
8plz 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
From India, Pune
Hi Pl check the attachment. it will help you to calculate completion date of probation period of an employee. Thanks
From India, Delhi
From India, Delhi
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)
From India, Pune
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
From India, Bangalore
=DOJ+(364/2)
Ex:
DOJ Confirmation due date
16-Dec-09 16-Jun-10
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.
From India, Mumbai
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.
From India, Chennai
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.
From India, Mumbai
From India, Mumbai
This is a very good short cut for calculation. Can you please provide for retirement at the age 58 years.
From India, Hyderabad
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.
From India, Mumbai
From India, Mumbai
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.
Date difference formula.xls
Excel Formula for Last Week Date.jpg