The office suite is an indispensable tool for an employee working in human resources management. And working with Excel spreadsheets is a daily task that an administrative employee must do.
One difficulty for new employees to Excel is to remember and use functions effectively, and get the results you want.
Through this tutorial, Download.com.vn will show you how to calculate the seniority of a list of employees in the company via Microsoft Excel spreadsheet or WPS Office.
Step 1 : Open the spreadsheet that has a list of seniority employees
Step 2 : Put the cursor in the cell to enter the seniority and enter the following formula (with C3 is the cell containing the start date of signing the Contract):
= DATEDIF (C3; TODAY (); "y") & "year" & DATEDIF (C3; TODAY (); "ym") & "month" & DATEDIF (C3; TODAY (); "md") & "date"
Step 3 : See the results after you enter the formula, refine it if necessary
Function : The DATEDIF function returns a value, the number of days, months or years between two optional intervals.
Structure : DATEDIF ( Day_dau , Day_cuoi , Tuy_chon )
Wish you always find the necessary knowledge at Download.com.vn!
Struggling with Microsoft Teams installation errors on Windows 11? Get step-by-step fixes for common issues like 0x80070005, 80070422, and more. Quick, effective troubleshooting to get you back to collaborating seamlessly.
Tired of Microsoft Teams "Screen Error" black screen ruining your meetings? Discover proven, step-by-step troubleshooting fixes for Teams black screen issues, screen sharing errors, and more. Get back to seamless collaboration fast!
Frustrated with the endless Microsoft Teams Update Error loop? Discover step-by-step fixes to resolve stuck updates, clear cache, reinstall, and more. Get back to seamless collaboration fast!
Encountering Microsoft Teams "Download Error" on your phone? Get instant fixes for Android & iOS. Clear cache, update apps, and more—back to chatting in minutes without frustration!
Struggling with Microsoft Teams VOIP connection error? Discover step-by-step fixes to solve Microsoft Teams VOIP connection error instantly. Network tweaks, cache clears, and more for seamless video calls.
Tired of the frustrating Microsoft Teams 'Unexpected Error' on startup? Discover step-by-step fixes, from clearing cache to advanced resets, to get Teams running smoothly again. Quick, reliable solutions for Windows and Mac users.
Tired of Microsoft Teams "Download Error" Unexpected blocking your workflow? Follow our expert, step-by-step guide with quick fixes and advanced tips to resolve it instantly. No reinstall needed!
Oil heaters make noise, leak oil, and do not heat up. These are all problems that arise when using a heater. So what are the causes of these problems? Read our article below!
Master how to assign participants to breakout rooms in Microsoft Teams with this step-by-step guide. Boost meeting engagement, automate assignments, and troubleshoot like a pro for seamless virtual collaboration.
Struggling with Microsoft Teams "Price Error" after the latest pricing update? Discover step-by-step fixes to resolve it quickly, restore seamless collaboration, and avoid subscription headaches. Updated with the newest solutions.
Struggling with Microsoft Teams Background Error Transparency? Discover proven step-by-step fixes for blurry, glitchy virtual backgrounds. Restore perfect transparency in Teams meetings effortlessly. Updated with the latest solutions.
Struggling with Microsoft Teams "Đăng nhập" login error? Discover step-by-step fixes for smooth sign-in. Clear cache, update app, and more – no tech skills needed! Works on Windows, Mac, and web.
Tired of Microsoft Teams Web Error 503 Service Unavailable blocking your meetings? Discover quick, step-by-step fixes to resolve the 503 error fast – no tech skills needed! Clear cache, check status, and get back to collaborating seamlessly.
Stuck with Microsoft Teams Update Error 0x80070002? Discover proven troubleshooting steps to resolve this frustrating issue quickly and get your Teams app updated seamlessly for uninterrupted collaboration.
Tired of Microsoft Teams Error AADSTS50020 blocking your sign-in? Discover step-by-step fixes for user account conflicts, backed by the latest Azure AD solutions. Get back to work fast!
