Formula for Calculating Probation Months
Seeking a formula that calculates in dd/mm/yy format from the Date of Joining in cell one to the Date of Confirmation in cell two. What formula should be put in the second cell to automatically count probation months? For example, 14 May 2011 (6 months) 14 Nov 2011.
From India, Ahmadabad
Acknowledge(0)
Amend(0)
76Seeking a formula that calculates in dd/mm/yy format from the Date of Joining in cell one to the Date of Confirmation in cell two. What formula should be put in the second cell to automatically count probation months? For example, 14 May 2011 (6 months) 14 Nov 2011.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Suppose in Cell A1, you are writing the Start Date/DOJ, and in Cell B1, you wish to calculate the confirmation date, which is 6 months/180 days from the start date. Please follow the steps below:
1. In cell B1, type "=A1+180"
2. Right-click on the cell → Select Format Cells
3. Click on the 'Number' tab, select 'Date' option below, and choose the 'Date Type' (e.g., dd/mm/yyyy or dd-mm-yy).
Regards
From India
Acknowledge(0)Amend(0)
1. In cell B1, type "=A1+180"
2. Right-click on the cell → Select Format Cells
3. Click on the 'Number' tab, select 'Date' option below, and choose the 'Date Type' (e.g., dd/mm/yyyy or dd-mm-yy).
Regards
From India
Acknowledge(0)Amend(0)
Please find the attached document related to your first query. It will provide you with the exact date, as some months have issues with varying days. For example, February has 28 or 29 days, while some months have 30 or 31 days. However, the formula in the attached Excel sheet will work perfectly.
Regards,
Yajuvendra Singh Bisht
From India, Delhi
Acknowledge(0)Amend(0)
Regards,
Yajuvendra Singh Bisht
From India, Delhi
Acknowledge(0)Amend(0)
In Excel, how do you find the difference between two dates, e.g., Cell A1 "12/03/1983" and Cell B1 "23/07/1987" in the format dd/mm/yyyy? How do you calculate the number of days between the two dates?
Thanking you in advance.
From India, Delhi
Acknowledge(0)Amend(0)
Thanking you in advance.
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt
CiteHR.AI
(Fact Checked)-The user's reply is correct and provides clear instructions for calculating the confirmation date based on the start date. Well done! (1 Acknowledge point)