Amos Gikunda 
Diverse methods were discussed in our last write-up on how to change dates into texts. In this article, the reverse will be discussed, i.e., changing dates to texts in Excel. In doing this, we will look at some formula methods as well as some non-formula methods. The TEXT function of Excel is uniquely built to … Read more
Microsoft Excel offers various functions that enable users to work with days, months, and years. However, of all these, only one is designed for weeks – the WEEKNUM function. Hence, if you are looking for means or access to a week number from a date, WEEKNUM is your exact search. Based on the WEEKNUM as … Read more
Welcome to yet another exciting tutorial on our excel series. In this post, we will swiftly discuss the quickest way to deduce the initial day of the month from an excel spreadsheet. As we know, excel is never in short supply of intrigues, so let's proceed! As already stated, only one function is being present … Read more
A quick way of changing dates in Excel into text strings without using any formula is making use of Notepad or other text editors. Unlike the Wizard, this particular one enables you to change and transform dates in Excel to texts using any format or approach of your choice. 1. While using your Worksheet, configure … Read more
The guidelines on using the MONTH and EOMONTH functions of Excel are outlined in this tutorial. There are series of examples of getting the month from date. All you should do is get the first and the last day of the month, then change or convert the name of the month to a number and … Read more
This has to do with bringing out a name of a month from a specific date in Excel. As a core excel user, you are bound to come across a situation where you need to extract the name of a month from the date while working on excel. This tutorial will serve you the pertinent … Read more
There are lots of functions in the Excel worksheet that relates to dates and times. Despite this, the Worksheet is incapable of ascertaining the number of days present in a particular month. Due to this, we will devise a means to solve this omission. Example 1. How to get days numbers from month number By … Read more
As you are successfully conversant with the MONTH and EOMONTH Excel functions, you can decide to progress and make the visual display better. In doing this, the Excel conditional formatting for dates will be utilized. To further buttress on the examples given in the write-up above, you will be shown how to easily highlight cells … Read more
Two functions exist in Excel that can assist you in changing the names of months to numbers of months. They are the DATAVALUE and the MONTH function. The function of the DATAVALUE is changing a date saved as a text into a serial number which is recognizable by Microsoft Excel as a date. In comparison, … Read more
If you're looking for a way to change the present date to a text, all you need to know is to make use of the TEXT function in Excel together with the TODAY function, which returns the present date, e.g =TEXT(TODAY(), "dd-mmm-yyyy") The outcome of this operation will display 08-Mar-2015. If you would love to … Read more