# Quick to learn the time and dates functions

Uploaded time: August 17, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Quick to learn the time and dates functions

The key points of this lesson

In this lesson, we‘ve learned the following key points:

1. How do we express the time and date correctly in the function formula?

Under normal circumstances, you just need to enter the standard date format in the formula, such as 01/01/2022. Don't forget that the date should appear inside quotation marks.

If you want to express a certain month in the formula, you need to satisfy two conditions at the same time. That's because the number of days each month is not fixed and can be 30 or 31 days.

Take March 2022 as an example:

Condition 1: Greater than or equal to March 1, i.e. >= 01/03/2022

Condition 2: Less than or equal to March 31, i.e. <=31/03/2022

2. How do we separate the year, month, and day from the date?

The YEAR function can extract the year of the date; The MONTH function can extract the month of the date; The Day function can extract the day of the date.

3. How can we extract the hour, minute, and second of the time separately?

Similarly, the HOUR, MINUTE, and SECOND functions can extract hour, minute, and second of the time.

4. How do we use the DATEDIF function to calculate the employee's length of service?

- The DATEDIF function itself has very simple parameters, DATEDIF (Start_date, End_date, Comparison Unit)

can return the number of days, months, and years between two dates, which is one of the functions that HR must master.

- Besides, there are two functions else that are often used to calculate dates. NETWORKDAYS function can return the number of working days between two dates, and its function syntax is: NETWORKDAYS (Start_date, End_date, Holidays)

The WORKDAY function can return the end date based on the start date and the number of days required. Its function syntax is: WORKDAY(Start_date, Number of days, [Holidays])

PS:Time is by nature numerical and can be calculated as long as it is in a standardized format.

You'll Learn

The basics of WPS Spreadsheet.

The most commonly-used batch processing skills for increasing productivity.

Process large data in WPS Spreadsheet.

Master the popular PivotTables to create dynamic reports.

Nest dynamic formulas, including the IF, VLOOKUP, SUMIF, and MATCH functions to impress your leader.

Acquire skills in improving security, sharing, co-editing, and printing files.

Course Content

Start from beginners, from theory to practice, don't worry about learning

Basics of WPS Spreadsheet

6 lectures

3592 minutes

How to make a table efficiently

6 lectures

3664 minutes

Most commonly-used Formula Skills

5 lectures

3471 minutes

PivotTable

2 lectures

1329 minutes

Data Visualization

6 lectures

3709 minutes

Security and Painting

3 lectures

1896 minutes

You'll Get

- 300+ Mins Videos
- 100+ Real Cases
- 40+ Practice Files

Comments

Catalogue

1. Basics of WPS Spreadsheet

1-1. Get to know WPS Spreadsheet

10m26s

1-2. Create a chart from scratch

8m59s

1-3. How to input data into a table efficiently

12m21s

1-4. How much do you know about data format

8m41s

1-5. How much do you know about data format 2

10m25s

1-6. How to carry out simple calculations in a table

9m

2. How to make a table efficiently

2-1. The Go to and Find & Replace function of data

11m15s

2-2. How to efficiently sort and filter data part

13m31s

2-3. Data validation to help you limit the content of your forms

11m12s

2-4. A few efficient ways to handle large data

9m14s

2-5. How to Process data with Text to Columns

7m31s

2-6. How to merge and split files

8m21s

3. Most commonly-used Formula Skills

3-1. Get started with functions and formulas

10m29s

3-2. Most-used Statistical Functions

11m28s

3-3. Do you really know about the Logical functions?

11m52s

3-4. Quick to learn the time and dates functions

11m58s

3-5. A magical function everyone needs to know: VLOOKUP

12m4s

4. PivotTable

4-1. Use PivotTable to analyze data

11m54s

4-2. Use PivotTable to analyze data 2

10m15s

5. Data Visualization

5-1. Apply conditional formatting to data

11m12s

5-2. Use charts to present data

9m15s

5-3. Different ways to utilize column charts

11m5s

5-4. Line Charts and Area Charts

9m37s

5-5. Pie Charts and Sparklines

10m2s

5-6. Beautify The Table

10m38s

6. Security and Painting

6-1. How to protect your worksheet and workbook

9m35s

6-2. Share and revise workbooks

9m38s

6-3. How to print a table

12m23s

Does this video help you?