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....

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 ....

How to analyze trends with TREND function in WPS Office Excel

In this article, you will know how to analyze trends with TREND function in WPS Office Excel with simple steps as following: · Know about the TREND function in WPS Spreadsheeto Principle of the TREND functionThe TREND function predicts the linear increasing amount based on the current data (y=mx+b).o Syntax of the TREND functionTREND([known_y's], [known_x's], [new_x's], [logical values]) o Explanation of the TREND functionKnown_y's (required): the set of y-values you al....

3 ways to add days to excel date (Easy Formula)

You could have encountered circumstances where you wanted to extend a date by a specific number of days. Let's say your business only permits you to send an ordered item out for delivery after a specific number of days. Alternatively, you may have a payroll system that only permits you to distribute a person's paycheck following a certain security period. As a result, you will need to determine the date that each employee's salary will be sent and record it in a different column. It i....

How to add year to date in excel

Excel add Year-to-Date in WPS office - The Definitive Guide A year to date is the period from the beginning of the current calendar year or fiscal year up until the present day. This information can help analyze business trends over time or compare performance data with competitors or peers in the same industry.YTD is calculated by subtracting the start-year value from the current value, dividing the result by the start-year value, and multiplying by 100 to convert it to a percentage Y....