Category: Excel Formulas

Text Function│Data Formatting Dates are stored as serial numbers in Excel and they can be switched from one format to another. If the dates in the file display as …

Value and Text Function│Date Value Function│Data Formatting Dates are stored as sequential serial numbers even the display can be very different, for example, 5/18/2011 or May 18, 2011. To …

Text Function│Data Formatting To convert a date to the month name, you can use the Text Function. Otherwise, please check how to convert a date to the month numbers. …

Text Function│Data Formatting If you want to convert a date to the weekday, you can use the Text Function to return a text string. Otherwise, please check how to …

Text Function│Data Formatting When working with dates, you often need to covert a date into a year number. You can use the Year Function or the Text Function. When …

If you have a date and want to convert into a month in number, you can use the Month function or the Text Function. When using the Month Function, …