Staff Skills academy+
Home » Courses » Microsoft Excel Advanced Certification » Module 17: DATEVALUE Function
Module 17: DATEVALUE Function
17.1 DATEVALUE Function The DATEVALUE function in Excel will convert a date that is displayed as text to the serial number that Excel uses to recognise the date. The DATEVALUE function can be particularly useful if you would like to make calculations or sort information based on a specific date. The formula is written as: =DATEVALUE(date_text) Date_text - This is the date that you would like Excel to convert to a serial number. It is worth noting that the first date that can be used...
Lessons
- Module 1: Add a Password
- Module 2 : AND Function
- Module 3 : Auto Updating Drop-down Lists
- Module 4 : CEILING Formula
- Module 5 : Charts that Update Automatically
- Module 6 : CHOOSE Formula
- Module 7 : Compare 2 Lists with VLOOKUP Function
- Module 8 : CORREL Function
- Module 9 : Create an Advanced Calculator
- Module 10 : Create a Combo Chart
- Module 11 : Create a Custom Tab
- Module 12 : Create a Pivot Chart
- Module 13 : Create Visual In-cell Indicators
- Module 14 : Create Visual In-cell Indicators with Icon Sets
- Module 15: Customise the Status Bar
- Module 16: DATEDIF Function
- Module 17: DATEVALUE Function
- Module 18: DAVERAGE Function
- Module 19 : DCOUNT Function
- Module 20 : DCOUNTA Function
- Module 21 : Depreciation Formula
- Module 22 : DGET Function
- Module 23 : DMAX Function
- Module 24 : DPRODUCT
- Module 25: DSUM Function
- Module 26: EDATE Function
- Module 27: EOMONTH Function
- Module 28: Find and Replace
- Module 29: FIND Function
- Module 30: INDEX Function
- Module 31: INDEX MATCH Function
- Module 32: INDIRECT Function
- Module 33: Insert Serial Number Automatically
- Module 34: IPMT Function
- Module 35: ISBLANK Function
- Module 36: ISERR Function
- Module 37: ISLOGICAL Function
- Module 38: ISNONTEXT Function
- Module 39: ISNUMBER Function
- Module 40: ISODD Function
- Module 41: Isolate First Name
- Module 42: ISTEXT Formula
- Module 43: LEFT Function
- Module 44: LEN Function
- Module 45: MATCH Function
- Module 46: VLOOKUP Multiple Results at Once
- Module 47: OR Function
- Module 48: PMT Function
- Module 49: REPLACE Function
- Module 50: Select all Cells with Comments
- Module 51: Sparkline Charts in Excel
- Module 52: Straight Line Depreciation
- Module 53: Strikethrough
- Module 54: Sum of Years Depreciation
- Module 55: Timeline in Pivot Table
- Module 56: VLOOKUP with 2 Criteria
- Module 57: VLOOKUP with DropDown List
- Module 58: VLOOKUP with MAX
- Module 59: VLOOKUP with MIN
- Module 60: Watch Window In Excel
