0704 Date Formulas - TEXT()

3 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hi there. This time, let me talk about the text Formula One of the very important formulas for presentation of data into a certain desired custom format. In this case, I have a couple of dates for June 2011, which I want to present in this form either Friday, or fry, or 033 indicates what indicates the third of third of June. So the formula goes like this text. First thing it asks for is the value, I choose the date value. Next, it asks for what is the desired format of output.

So in double quotation, I give BD DD four times d, I close the double quotation, I close the bracket thereafter, as soon as I press enter, what I get is Friday. Now had I put in just tripled the I would have got the short form of the day, and had I put just two times the letter D, I would have got the actual dates 03. Similarly, I can also apply this formula, if I wish to find out the month name, I choose the date comma, double quotation, double n double a double quotation close close the brackets and enter. So, if you wish to find just the shorter form of the month name, you would have used just three times the letter M. Similarly, if you want to find out the calendar month sequence of the month June then just to M will be sufficient enough and goes without saying that if you had written text formula and chosen the date and written double y double y in the double quotation, you would have got the year 2011.

Now, what specifically is this format, now this format text is the one which you generally get to see inside format cells. When I go to custom, so any of these format which is generally found under custom format can be enclosed in the pair of double quotation. So for example, if there is a format which I prefer to have on my screen with respect to date, I can use a combination of DD mmm and y, y, y in that sequence. For example, equal text, choosing the date, comma, then double quotation, I'm writing DD dot m dot y, y, y y, I close the double quotation, I close the bracket and I press enter. There you go. I have the date in 0306 2011.

And this is also useful when you are combining the date with a prefix word date. And then you're combining with a actual date. You notice it gets converted to a number. Now this will happen why because every validate is a number. So make sure that you apply the text formula before you choose the number in this case, using DD hyphen, mmm, hyphen y y double quotation close using the brackets enter. So this way you have been able to concatenate or combine the word date with the date That you would wish to point to in a desired format.

So that was text formula

Sign Up