Excel - Functions for working with text and calendar dates

You will learn to use functions from the DATE, TIME category. We will guide you through the most frequently used functions in this category. You can use TEXT functions to extract characters from a cell. Whether you have serial numbers, contract numbers or an EAN code, text functions are a powerful tool for extracting specific characters. 

Basics of working with PC and Excel.

To all Excel users.

Date and time functions

• TODAY - TODAY
• NOW
• DENTY WEEK - WEEKNUM
• ISOWEEKNUM
• ROK - YEAR
• MONTH - MONTH
• DEN - DAY
• DATE - DATE
• WORKDAY
• NETWORKDAYS

Text functions

• LEFT
• REPORT - RIGHT
• PART - MID
• LENGTH - ONLY
• FIND - FIND
• CONCAT
• CONCATENATE
• CLEAN - TRIM

• Know the functions DATE, TIME.
• Know TEXT functions.