• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

5 Date And Time Functions For Salary Calculation In Excel

0 Comments

In a previous article, Buffcom.net explored some functions in Excel such as VLOOKUP and HLOOKUP. In this article, we introduce to our readers 5 date functions commonly used in salary calculation on Microsoft Excel 2016. Let’s learn and remember them with Buffcom.net.

DATEDIF Function

This is the most commonly used date function in salary calculation, used to count the number of days, months, years, etc. between two specific dates.

Formula: =DATEDIF(start_date,end_date,unit)

Date And Time Functions For Salary Calculation In Excel 1Where:

  • start_date: the start date
  • end_date: the end date
  • unit: the type of information you want to receive, including y, m, d, md, ym, yd (remember to place in double quotes)
  • y: the total number of years rounded down from the start date to the end date
  • m: the total number of months rounded down from the start date to the end date
  • d: the total number of days from the start date to the end date (equivalent to the DAYS function)
  • md: the number of days between the start date and the end date, ignoring the number of months and years
  • ym: the number of months between the start date and the end date, ignoring the number of days and years
  • yd: the number of days between the start date and the end date, ignoring the number of years

For example, we can calculate the time period between two dates of 1/6/2020 and 28/7/2021, which is 422 days (result when using the d unit).

TODAY Function

This is a simple yet extremely useful function when combined with other functions in formulas, showing the current date and always updating every time you open the Excel spreadsheet.

Syntax: =TODAY()

Date And Time Functions For Salary Calculation In Excel 2Similar to the TODAY function, there are other functions used to update the month, year, etc. such as the MONTH and YEAR functions.

NETWORKDAYS Function

Used to calculate the number of working days in a period, excluding holidays. (by default, Saturday and Sunday are considered holidays)

Syntax: =NETWORKDAYS(start_date,end_date,holidays)

Date And Time Functions For Salary Calculation In Excel 3Where:

  • start_date: the start date
  • end_date: the end date
  • holidays: a range of values representing holidays or non-working days on weekends. When leaving the holidays value blank, the period calculated includes only working days except for Saturday and Sunday.

However, when the company needs to calculate the number of working days but the weekly holiday is not on the weekend (Saturday, Sunday), we use the NETWORKDAYS.INTL function.

Syntax: =NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)

Date And Time Functions For Salary Calculation In Excel 4Weekends represent regular weekly days off, interpreted as a sequence of 7 characters in double quotes with 1 as a day off and 0 as a workday. If the weekends are left blank, Excel defaults to Saturday and Sunday as regular days off. For example, “0100011” represents the weekly days off on Tuesday, Saturday, and Sunday.

The WORKDAY Function

When you hire employees for a certain number of days, the WORKDAY function helps you calculate the last working day for the employee, based on the agreed-upon number of workdays.

Syntax: =WORKDAY(start_date,days,holidays)

Date And Time Functions For Salary Calculation In Excel 5Where:

  • start_date: the starting date of work
  • days: number of workdays
  • holiday: similar to NETWORKDAYS function

Similar to the NETWORKDAYS and NETWORKDAYS.INTL functions, the WORKDAY.INTL function has a similar meaning and syntax.

Syntax: =WORKDAY.INTL(start_date,days,weekend,holidays)

The WEEKDAY Function

The WEEKDAY function is a date function that returns the day of the week for a given date. By default, Excel defines Sunday as 1 and Saturday as 7.

Syntax: =WEEKDAY(serial_number,return_type)

Date And Time Functions For Salary Calculation In Excel 6Where: serial_number is the date given in Number or Date format, and return_type is how you want to display the result. If you enter:

1 or leave it blank, the week starts on Sunday (result of 1) and ends on Saturday (result of 7)
2: the week starts on Monday (result of 1) and ends on Sunday (result of 7)
3: the week starts on Monday (result of 0) and ends on Sunday (result of 6)
Additionally, the WEEKNUM function returns the week number of a given date in a year.

Syntax: =WEEKNUM(serial_number,return_type)

Summary of Date Functions

In Excel payroll, in addition to date functions, you will need to add other conditional functions and calculations to complete your own formula for your company.

In this article, Buffcom.net introduced the top 5 date functions for Excel payroll:

  • DATEDIF Function
  • TODAY Function
  • NETWORKDAYS Function
  • WORKDAY Function
  • WEEKDAY Function
    Also, if your job is closely related to Excel but the software does not meet your needs, contact Buffcom.net to choose the necessary product!
Rate this post
26
261 Views
Quick and Effective Way to Hide and Unhide Rows and Columns in ExcelPrevQuick and Effective Way to Hide and Unhide Rows and Columns in ExcelApril 11, 2023
What is a Dashboard? The Importance of Dashboards in Data AnalysisApril 11, 2023What is a Dashboard? The Importance of Dashboards in Data AnalysisNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
  • Microsoft Office Home And Business 2019 CD Key for MAC Global Microsoft Office Home And Business 2019 CD Key for MAC Global
    Rated 4.95 out of 5
    $30.00
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail Key Global - 5 PC
    Rated 4.96 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows 10 Home Key Global Windows 10 Home Key Global
    Rated 4.81 out of 5
    $10.00
  • Microsoft Visio Professional 2021 Key 1PC Microsoft Visio Professional 2021 Key 1PC $13.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.