Formula For Calculating Date Of Confirmation In Excel

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

reetugour

Hi
Pl check the attachment. it will help you to calculate completion date of probation period of an employee.
Thanks

1 Attachment(s) [Login To View]

Mayur Shinde HR

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)

Jagu1984

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

suhaskhambe

Hi P. U.,
Please find attached herewith the spreadsheet with the formaula as if yoiu needed.
Kindly use this file for your future use.

idy_o

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.

suhaskhambe

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.

snsitaram

This is a very good short cut for calculation. Can you please provide for retirement at the age 58 years.

suhaskhambe

Hi,
Please find attached herewith the retirement AGE calculator. it will give you the best result as you wanted. please give your feedback.

1 Attachment(s) [Login To View]

snsitaram

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.

PAGE

Next

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute