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)
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
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you very much. It is very helpful to work on this kind of date calculations in Excel. I believe someone in the forum may share more shortcuts that are useful in our activities, such as gratuity period calculation, etc.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi, Please change Date of Joining to Date of Birth in the excel column name. There was Typo error.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hello, use this formula as =EDATE(DOJ,6). You will get the exact date of confirmation. Regards, Ranjita
From India, Kolkata
Acknowledge(0)Amend(0)
From India, Kolkata
Acknowledge(0)Amend(0)
Hi Suhas,
The Excel file is good and useful, but there is a little correction needed. Since the date of birth is required to calculate the age, the column you mentioned (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
From India, Calcutta
Acknowledge(0)Amend(0)
The Excel file is good and useful, but there is a little correction needed. Since the date of birth is required to calculate the age, the column you mentioned (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
From India, Calcutta
Acknowledge(0)Amend(0)
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
From India, Anantapur
Acknowledge(0)Amend(0)
From India, Anantapur
Acknowledge(0)Amend(0)
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
From India, Ambala
Acknowledge(0)Amend(0)
From India, Ambala
Acknowledge(0)Amend(0)
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
From Pakistan, Lahore
Acknowledge(0)Amend(0)
From Pakistan, Lahore
Acknowledge(0)Amend(0)
Hi,
The best way to calculate the date and days for a new joiner is mentioned below. Please use the below-mentioned formulas 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
This format will automatically update the current date and days, eliminating the need for manual calculations.
From India, Mumbai
Acknowledge(0)Amend(0)
The best way to calculate the date and days for a new joiner is mentioned below. Please use the below-mentioned formulas 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
This format will automatically update the current date and days, eliminating the need for manual calculations.
From India, Mumbai
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
HR Manual (Employee Hand Book).doc
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip