No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


suhaskhambe
120

Hi, Please change Date of Joining to Date of Birth in the excel column name. There was Typo error.
From India, Mumbai
ranjita_23
15

Hello, use this formula as =EDATE(DOJ,6). You will get the exact date of confirmation. Regards, Ranjita
From India, Kolkata
Anonymous
hi suhas,
excel file is good and useful but there is a little correction needed. since the date of birth is required to calculate the age hence the column you mention (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
prasad715
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
AjayDhiman8836
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
Renjen
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
ankitchaturvedi
392

Hi,
The best way to calculate the date and days for a new joinee is mentioned below. Please use the below mentioned formulae 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

From India, Mumbai
hrcwpl@commanderwatertech.com
hi M trying to find the Confirmation Date by using =+C2+(362/2) its not reflecting its Showing an Error Please help me
From India, Pune
Shelly VJ
Mr. Suhas and Reetu, much appreciation for sharing such useful formulas. Thank you so much.
From India, New Delhi
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.





About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.