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
From India, Pune
8plz 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
From India, Pune
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
From India, Pune
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
From India, Mumbai
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
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Date difference formula.xls
Excel Formula for Last Week Date.jpg