Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. Otherwise, we can convert the cells containing dates to text using Excel’s Text to Columns tool.Ĭlick here to download the sample Excel file Additional Resources Hence, if we attempt to use the RIGHT function on a date, it will return the start characters of the number that represents that date.įor example, is represented by the number 29221, so applying the RIGHT function to a cell containing the date (and requesting that 4 characters be returned) will result in a returned value of “9221.” If we wish to use RIGHT on dates, we can combine it with the DAY, DATE, MONTH or YEAR functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |