Excel Functions: DateValue TimeValue
This video will demonstrate how to use the below functions to convert stored text to a serial number that Excel recognizes, we will also demonstrate how to use each function in a formula
1) DATEVALUE Function
2) TIMEVALUE Function
Section Ten - Date and Time Functions
*Complete as part of section ten and be sure to checkout the section reference guide.
*Complete the quick quiz and practice assignment once your have completed the section.
Section Ten Playlist includes
1. Introduction to Date/Time Functions in Excel
2. Date Functions (Today, Year, Month, Day, Date)
3. Time Functions (Now, Hour, Minutes, Second, Time)
4. Dated IF (difference in years, months, days)
5. Days Function: Calculate the Number of Days between two dates
6. EDate
7. EOMonth Function: How to use the End of Month(EOMONTH)function
8. NetworkDays/NetworkDays.INTL
9. DateValue and TimeValue Uses
Important Links
https://myexcelpower.com/wp-content/u... (Customize Worksheet)
https://myexcelpower.com/wp-content/u... (Section Reference Guide)
https://myexcelpower.com/excel_dateti... (Quick Quiz)
https://myexcelpower.com/wp-content/u... (Practice Assignment)