00:00Recently, someone came to my desk to ask me, how do you show a day in short form and long form?
00:05What I mean by short form is like T-H-U-R for short and long is spelled the whole word itself.
00:11This is how I do it. You're going to have to say equal text open parenthesis
00:15and then the first argument on the text will be the date itself, comma, double quote
00:20and if you put 3D like this, it will give you a day in short format.
00:25It will show as T-H-U, but if you need a long format, you're going to have to use a text function again like this
00:31and then if you put 4D like this, one, two, three, four, close double quote and the parenthesis like this
00:37it will give you Thursday completely spelled and for month, same thing again
00:42you're going to use a text formula or function and then if you type 3M like this
00:47it will give you a month in an every-rated format like August like this
00:51and then let's say for example, if you were to put 4M like this
00:56it will give you a month fully spelled out nicely for you
01:00years is a bit different
01:02I'm going to have to use the same thing again
01:04years is represented by two Ys to indicate year as the last two digits of the year
01:11and if you want the full long year, you're going to have to type four Ys like this
01:16and close parenthesis
01:17and for date format, let's say for example, if you're nicely formatted
01:21you're going to have to use the text format
01:22and you can combine all these things that you have just learned today
01:25I'm going to use this day, comma
01:28and I'm going to say the day, I'm going to present it nicely
01:32I'm going to say Thursday itself
01:33so I'm going to say D, D, D, D, comma
01:36and if you put a single D like this, it will show you the date itself
01:39which is 16 according to cell 2A
01:43and then space, and then month, if you want to spell partially short like August, A, U, G
01:49you just do like that
01:50if you want full August, you put 4Ms
01:53I'm going to put 3Ms to iterate my month
01:56and for year, I'm going to present it with a full four digit year
02:00like this
02:01and close double quote
02:02and then close parenthesis like this
02:04and you'll present it that way
02:05let's say for example, August
02:07let's say you want to fully spell it
02:08let me show you here
02:09this is what it looks like
02:10so now if you were to take this and apply to the rest of the row
02:13it will come up nicely
02:14one thing I want to point to you about the year is that
02:17if the year is 2008
02:19the leading number will be 0 here
Comments