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!
Unlock the power of Microsoft Teams transcription for meetings with this step-by-step guide. Learn how to enable transcription, prerequisites, and tips for accurate transcripts to boost productivity and accessibility. Perfect for teams in 2026.
Tired of Microsoft Teams "Unknown Error" crashing your meetings? Discover step-by-step troubleshooting fixes that work instantly. Clear cache, reset app, and more—no tech skills needed!
Not all supplements are beneficial for irritable bowel syndrome (IBS), some may even worsen your symptoms.
Struggling with Microsoft Teams Error AADSTS70008: Expired Security Token? Discover step-by-step fixes, from quick sign-outs to advanced cache clears, to get back to seamless collaboration instantly. Updated with the latest solutions.
Tired of Microsoft Teams Error C Data crashing your meetings? Get proven, step-by-step solutions to clear cache, reset, and restore seamless teamwork. Fast, reliable fixes for the latest Teams versions.
Discover how to use Microsoft Teams background images effectively with step-by-step guides, custom upload tips, and best practices to make your video calls professional and engaging. Elevate your remote work game today!
Discover how to use Microsoft Teams Web App on any browser effortlessly. Step-by-step guide, tips, and troubleshooting for smooth collaboration anywhere. No downloads needed!
Tired of the frustrating Microsoft Teams "User Not Authorized" error blocking your meetings? Discover proven, step-by-step solutions to fix it fast and reclaim your productivity. Works on desktop, web, and mobile.
Struggling with Microsoft Teams errors on iPhone or iOS? Discover step-by-step fixes for crashes, sign-in issues, and more. Get back to seamless teamwork in minutes—no tech expertise needed!
Battling Microsoft Teams Tasks sync error? Get instant relief with our proven, step-by-step fixes for Tasks not syncing in Teams. Boost productivity now—no tech expertise needed!
Unlock the power of Microsoft Teams Breakout Rooms with this 2026 beginner tutorial. Step-by-step guide to create, manage, and elevate your virtual meetings effortlessly. Perfect for educators, teams, and beginners!
Struggling with Microsoft Teams "Error N" network errors? Get step-by-step fixes for Solving Microsoft Teams "Error N" Network problems, from quick restarts to advanced troubleshooting. Restore seamless calling and meetings now!
Tired of Microsoft Teams "Media Error" ruining your video shares? Follow our step-by-step guide with the latest fixes to get videos playing smoothly again – no restarts needed!
Tired of Microsoft Teams "Code Error" blocking your redemption? Get proven, step-by-step Troubleshooting Microsoft Teams "Code Error" Redemption solutions. Clear cache, update, and redeem successfully—fast and easy!
Stuck with Microsoft Teams "Error QSP" during installation? Follow our step-by-step guide with quick fixes to resolve the issue fast. Updated for the latest Teams versions—no tech skills needed!
