Get Digital Help
  • Home
  • Functions
  • Formulas
  • Charts
  • CF
  • Pivot tables
  • VBA
  • Archive
  • Contact

    DATE function

    DATEVALUE function not working

    Days between 2 dates

    How to use the DATE function

    Date from week & day

    Find date range

    Identify overlapping date ranges

    Find latest date based on a condition

    Calculate last date of a given month


    DATEVALUE function

    DATEVALUE function not working

    How to use the DATEVALUE function


    LEFT function

    Convert column number to column letter

    DATEVALUE function not working

    First word in cell value

    First three digits in value

    How to use the LEFT function

    Extract unique distinct values based on the 4 last characters

    Formula for matching a date within a date range

    Sum values containing text based on a condition


    MATCH function

    Convert column number to column letter

    DATEVALUE function not working

    Match a range value containing both text and numerical characters

    Get the latest revision

    Opposite numbers

    Critera - multiple results

    Case sensitive

    Multiple results

    Match two columns

    Multiple conditions

    Dynamic scoreboard

    Merge tables based on a condition

    How to use the MATCH function

    Match a criterion and extract multiple corresponding table headers

    Calculate average of last 10 data with possible blank cells

    Extract unique distinct values based on the 4 last characters

    5 easy ways

    Extract largest values from two columns

    Two-dimensional lookup

    Create a unique distinct list and sort based on frequency

    How to automatically fill all blanks with missing data or formula

    Sort a column alphabetically

    Find closest value


    MID function

    Pattern in cell value

    K-th word in cell value

    DATEVALUE function not working

    Match a range value containing both text and numerical characters

    Numbers in cell value

    How to remove unwanted characters in a cell

    Identify all characters in a cell value

    How to remove numbers from a cell value

    How to use the MID function

    Create name initials

    Extract numbers from a value

    Fuzzy vlookup [Array formula]

    Extract unique distinct values based on the 4 last characters

    Exact word in string


    RIGHT function

    DATEVALUE function not working

    Last word in cell value

    How to use the RIGHT function

    Extract unique distinct values based on the 4 last characters

    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


DATEVALUE function


Excel » Functions » Date and Time » DATEVALUE function »

DATEVALUE function not working

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. However, it must […]

How to use the DATEVALUE function

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you out.

    Feel free to comment and ask Excel questions.

    Make sure you subscribe to my newsletter so you don't miss new blog articles.

  • Free Blog Emails

    Get a free PDF book!

  • Search website