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.
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 Confirmation due date
From India, Bangalore
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
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.
From India, Hyderabad
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.