Home / Tech / Excel Basics / 3.3 Entering Date Values in Excel

3.3 Entering Date Values in Excel

We have talked about two different types of data that you can input into an Excel document. There is actually a few more and I want to talk a little bit about one of the other types of data that you are going to be inputting into an Excel spreadsheet. We have talked about alpha characters.

Another type of data that you are going to be working with inside of excel are Dates.

So, let us talk a little bit about dates. We have got some months I mean that is a portion of a date, that is a date valued but it is not a complete date. Right dates they typically contain three different aspects or three different elements that make up the date that you have got the day the month you got the month and you got the year. So, we really got those three pieces.

Depending on what region you live in your dates may be formatted a little bit differently. Do you do day first do you do month first? What does your years look like? Right there is lots of different ways to build a format dates but dates typically contain those three pieces of information.

Let us say for our months here maybe I am going to be using this one spreadsheet for multiple years.

I want to designate I want to denote which year this month belongs to. I am going to go up into my January which is be three and I mean it is going to Double Click into that cell Double Click enters into that cell I can now edit it.

I am going to say January-2020, I am going to hit my Tab key cop out of that cell in a minute two things just happen there.

Entering Date Values in Excel 1

Let us get back and fix this one, Double click that cell. We are now working with a date value.

Entering Date Values in Excel 2

A couple of things happened, they are now right aligned they are on the right-hand side of the cell. Remember that discussion that is supposed to happen with numeric values. Well, you know what, instead of Excel and most applications, dates are treated as numeric values, best way goes they are numeric.

You saw when I double clicked inside of there you, actually, get a date format.

We have now got some date values and underlining once again and I can see this up above here inside of my formula bar that we have actually got a date it is right aligned it is numeric it is a date value treats it as such but underlining that is a date.

Entering Date Values in Excel 3

What I am going to do here and this is something we are going to get much more depth than too as we continue through, when we start to get into the formatting section of this book is, I want to format these cells.

I am going to highlight B3 to D3, then I am going to go to Home tab top my screen and I am going to go into the numbers section right underneath.

Entering Date Values in Excel 4

We can currently see that it says custom typically that I will say a general, if I go to any other cell, we will see general inside of that box there it is general well here with that selected.  I am going to go up here to a little dropdown and we have got some default formatting options.

Scroll down we have got a whole bunch of other stuff inside of there but down at the bottom we have an option for more number of formats.

Entering Date Values in Excel 5

I am going to go into more number formats here underneath category.

Entering Date Values in Excel 6

I can format cells by selected Custom and enter type format from my keyboard.

Entering Date Values in Excel 7

And the result, we have them nice months.

Entering Date Values in Excel 8

That was a few steps that we went through. Always feel free in any of the lecture, just leave it the way that you want or come up with another format.

Go to Review of this book to make your questions and get answers right now, I love answering questions, I love seeing the work that my students do. Share with us take a screenshot add it to the post let us know what you are doing.

Get this portion done, get your dates in there, Looking good. We will jump into the next lecture. I am excited, we are going to be getting into some formulas.

About admin

Check Also

Excel Decimal Data Validation 1

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. …

Leave a Reply

Your email address will not be published. Required fields are marked *