❮ Previous Next ❯

Text & Date Functions

  • Master text manipulation and date calculations in Excel.

  • LEFT Function

    Purpose: Extracts characters from the left side of text.

    Syntax:

=LEFT(text, num_chars)

  • Example:
     A1 = Daksha Rajput

=LEFT(A1, 6)

  • Output: Daksha


    RIGHT Function

    Purpose: Extracts characters from the right side of text.

    Syntax:

=RIGHT(text, num_chars)
  • Example:
     A1 = Daksha Rajput

=RIGHT(A1, 6)

  • Output: Rajput


    MID Function

    Purpose: Extracts characters from the middle of text.

    Syntax:

=MID(text, start_num, num_chars)
  • Example:
     A1 = Daksha Rajput

=MID(A1, 8, 6)

  • Output: Rajput

    Use Cases:

    • Extract username from email

    • Extract specific part of product code

    • Extract branch code from ID number

    Date Functions in Excel

    Date functions are used for time-based calculations.


    TODAY Function

    Purpose: Returns the current date.

    Syntax:

=TODAY()

  • Useful for:

    • Daily attendance sheets

    • Invoice dates

    • Auto-updating reports


    NOW Function

    Purpose: Returns the current date and time.

    Syntax:

=NOW()

  • Useful for real-time dashboards and tracking.


    DATEDIF Function

    Purpose: Calculates the difference between two dates.

    Syntax:

=DATEDIF(start_date, end_date, unit)

  • Units:

    • "Y" → Years

    • "M" → Months

    • "D" → Days

    Example:
     A1 = 01-01-2020
     B1 = 01-01-2025

=DATEDIF(A1, B1, "Y")

  • Output: 5

❮ Previous Next ❯