Hi,
Please help me in calculating, in Excel, the date of confirmation (6 months) of an employee calculated from the date of joining in YY/MM/DD format. This calculation must update regularly as per the system clock.
Regards
From India, Pune
Acknowledge(0)
Amend(0)
8Please help me in calculating, in Excel, the date of confirmation (6 months) of an employee calculated from the date of joining in YY/MM/DD format. This calculation must update regularly as per the system clock.
Regards
From India, Pune
Acknowledge(0)Amend(0)
Hi Pl check the attachment. it will help you to calculate completion date of probation period of an employee. Thanks
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Hope, your company has a 6-month probation period for all new members. In that case, you can use the following formula to calculate the exact confirmation date:
=DOJ + (364/2)
Example:
DOJ Confirmation due date
16-Dec-09 16-Jun-10
From India, Bangalore
Acknowledge(0)Amend(0)
=DOJ + (364/2)
Example:
DOJ Confirmation due date
16-Dec-09 16-Jun-10
From India, Bangalore
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Chennai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
This is a very good short cut for calculation. Can you please provide for retirement at the age 58 years.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Date difference formula.xls
Excel Formula for Last Week Date.jpg