The WEEKDAY Function in EXCEL

· Description:Weekday Function can return a number from 1 to 7 identifying the day of the week of a date. In today’s tutorial, we will also learn how to combine WEEKDAY with nested IF&OR function. · Syntax:(Serial_number, Return_type) · Arguments:Serial_number: The number that represents a date.Return_type: You can enter a number here: 1: Returns a number from 1 to 7, meaning start from Sunday and end at Saturday. It’s the default if omitted.2: Returns a number from 1 to 7, meaning st....

HLOOKUP Function in Excel

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. · Description:The HLOOKUP function can look up a value in the top row of values and returns a value in the same column from a row that you specify. · Syntax: HLOOKUP(lookup_value, table_array, row_num, range_lookup) · Arguments:Lookup_valueThe value to be found in the first row of the table. (can be a value, a reference, or a text string).Table_arrayThe table of text, numbers, or logic....

DATEDIF function in EXCEL

· Description:Except for DAYS360 function(hyperlink), there is another more powerful function to calculate dates that are not in the same year. The DATEDIF function is mainly used to count the number of days, months or years between two dates.· Syntax:DATEDIF(start_date, end_date, comparison unit)· Arguments:Start_date: A serial date number that represents the start date.End_date: A serial date number that represents the end date.Comparison unit: The type of result you want to return.I....

The MINUTE Function in Excel

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.· Description:MINUTE function returns the minute as a number from 0 to 59.· Syntax:MINUTE(Serial_number)· Arguments:Serial_number: A number in the date-time code used by WPS spreadsheets, or text in time format.· Example:Suppose we have the starting time (8 AM) and end time of different products on sell and we want to calculate how long it took for each item to be sold out.1. Select....

The DAYS360 function in Excel

· Description:DAYS360 returns the number of days between two dates based on a 360-day (30 days a month, 12 months a year), which can be used in some accounting calculations.· Syntax:DAYS360(start_date, end_date, method)· Arguments:Start_date and end_date are the two dates between which you want to know the number of days.Method is a logical value specifying the calculation method.FALSE or omitted: U.S.(NASD) method. If the start_date is the last day of a month, it is seen as the 30th ....

The HOUR function in Excel

· Description:HOUR function returns the hour as number from 0 (12:00 AM) to 23 (11:00 P.M).· Syntax:HOUR(Serial_number)· Arguments:Serial_number: A number in the date -time code used by WPS spreadsheets, or text in time format.· Example:Suppose we have the employees' clock-in time and want to return their entry hour. What can we do with the help of the HOUR function?1. Open your table with WPS Spreadsheets.2. Select cell C3 where we want to calculate the entry hour of Mike. We ....

The TRIM Function in Excel

Want to Learn Excel? Here is a WPS Spreadsheet online training that will teach you all the basics and advanced skills. Download WPS Office, easily find more about spreadsheet formulas, data, and cells in WPS professional spreadsheet tutorials. · Description:The TRIM function removes the leading and trailing spaces and the unnecessary spaces between words. When receiving the text with irregular spacing, you can use TRIM to modify quickly and easily. · Syntax:=TRIM(text) · Arguments:Text....

Between two numbers formula in Excel

We may need to compare values when analyzing data. Here we will talk about how to mark the values that are between two given values. Here we take a table as an example. We want to know whether the values are between "Number 1" and "Number 2."We can use this formula: =AND(val>MIN(num1,num2),valMIN(A2,B2), C2