The use of Text function in getting the day and month from the given date
Excel Tip #001 The use of Text function in getting the day and month from the given date Sometimes we may want to know the day and month of the given date. In such cases, we can make use of the TEXT function to retrieve the information. The formula to show current date is using TODAY() function. =TODAY() The functionality of TEXT function is to convert a value to text in a specific number format. Here we are going to use the same function to convert date into days & months. =TEXT(value,format_text) In the value field, we are going to assign a date and in format_text field we can define d, m (or) y (date, month & year respectively) based on the output that we are expecting. Let us now consider the date 6/15/2014 (June 15, 2014) which is the value field. This date is defined in the cell B2 in my excel. Assigning format_text "dddd" will return the day of the date. Formula: =TEXT(B2,"dddd") Assigning form...