COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
|
|
workday
|
|
|
date
|
|
|
networkday
|
|
|
weekday
|
Explanation:
Detailed explanation-1: -The NETWORKDAYS Function[1] calculates the number of workdays between two dates in Excel.
Detailed explanation-2: -The NETWORKDAYS function syntax has the following arguments: Start date Required. A date that represents the start date. End date Required.
Detailed explanation-3: -Explanation: In Excel, you can use the NETWORKDAYS function to calculate the number of workdays between two dates, excluding weekends and any holidays that fall within the specified range.
Detailed explanation-4: -NETWORKDAYS function calculates the total number of working days between start date and end date excluding weekends, and any date identified as holidays.
There is 1 question to complete.