How to indent cell content in Excel
In this video we show you how indents work in Excel, which alignment options they work with, and how to increase and decrease the indent level.
Dave Bruns
DATEVALUE Function
Sometimes, dates in Excel appear as text values that are not recognized as proper dates. The DATEVALUE function is meant to convert a date represented as a text string into a valid Excel date. Proper Excel dates are more...Read more
How to wrap text in cells in Excel
In this video we show you how to enable and disable text wrapping in cells.
How to create a custom time format
In this video we show you how to create your own custom time format.
YEAR Function
The YEAR function extracts the year from a given date as a 4-digit number. For example:
=YEAR("23-Aug-2012") // returns 2012
=YEAR("11-May-2019") // returns 2019
You can use the YEAR function to extract a month number from a date into a...Read more
DAY Function
The DAY function returns the day component of a given date as a number between 1 to 31 from a given date. For example, with the date January 15, 2019 in cell A1:
=DAY(A1) // returns 15
You can use the DAY function to extract a day...Read more
How to create a custom date format
In this video we show you how to create your own custom date format.
How Excel stores dates and times
In this video we explain how Excel stores dates and times.
How to create a custom number format in Excel
In this video we show you how to create your own custom number format.