WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1680 results for date and time functions

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        1680 results for date and time functions

        Quick to learn the time and dates functions

        Quick to learn the time and dates functions

        11:58

        Quick to learn the time and dates functions

        1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other

        Spreadsheet 10.3K views
        Insert date and time in the header or footer

        Insert date and time in the header or footer

        00:55

        Insert date and time in the header or footer

        WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

        Writer 18.3K views
        Create a countdown calendar & Insert current time and date

        Create a countdown calendar & Insert current time and date

        02:14

        Create a countdown calendar & Insert current time and date

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

        Spreadsheet 9.7K views
        Get started with functions and formulas

        Get started with functions and formulas

        10:29

        Get started with functions and formulas

        1. Reviewed the steps to insert functions in the table, there are 3 entrances to insert functions. You do not need to remember each function, just enter the first few letters, and the system will generate an automatic association.2. shared the 3 types of formula references, namely relative, absolute and mixed references.3. shared the function of how to reference data across worksheets or workbooks.

        Spreadsheet 12.0K views
        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 12.2K views

        Quick access to insert date and time into a sheet

        lShortcut to insert the date: CTRL + semicolom(;)lShortcut to insert the time: CTRL + quotation mark(") WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

        xls Spreadsheet 6.7K views

        Find and replace functions in Spreadsheet

        · Option 1:[Find]1. Click Home → Find and Replace → Find 2. Enter the keyword you want to find. [Replace]1. Click Home → Find and Replace → Replace2. Enter the keyword you want to find in the first box, with contents to replace with in the second box. 3. Click Replace to replace the items one by one. 4. You can also click Replace All to replace all items. · Option 2: Use short keys [Find] Ctrl + F [Replace] Ctrl + HTo be office excel advanced, you could learn how to use WPS O....

        xls Spreadsheet 11.3K views
        Make a countdown calendar in WPS Spreadsheet

        Make a countdown calendar in WPS Spreadsheet

        01:37

        Make a countdown calendar in WPS Spreadsheet

        It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

        Spreadsheet 7.6K views
        Prev 1 2 3 ... 209 210 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube