![]() ![]() ![]() This can be useful to find the difference between year, month, and day. Total Tenure, we need to use the DATEDIF function.ĭATEDIF function is an undocumented formula where there is no IntelliSense list for it. If we just deduct the relieving date with the joining date, we get the only number of days they worked we get in detail. DATE function alone cannot do the job for us. Here we need to use the DATEDIF function to get the result as per our wish. Next, you need to find the total tenure in the company. For example, assume you are working in an HR department in a company, and you have employee joining date and relieving date data. We need to combine these three columns and create a full date.Įnter the above into an excel sheet and apply the below formula to get the full date value.įind the difference between two days in terms of Total Years, Total Month, and Days. In the first column, we have days in the second column, we have a month and in the third column, we have a year. ![]() You can download this DATE Function Excel Template here – DATE Function Excel Template Example #1įrom the below data, create full date values.
0 Comments
Leave a Reply. |