Excel: formula to get auto serial, day, month and year

Asked By kbe123 10 points N/A Posted on - 09/21/2011

Hi,

I have been doing data entry work for a big company and I always do my work in an Excel file. I do huge work so I would like to get auto serial for day, month and year so that I can do huge work easily quickly.

Please suggest anything to me.

• Status: Open
• Question Views: 1265
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By Abigeal 0 points N/A #122167

Excel: formula to get auto serial, day, month and year

Hi Kbe123,

Yes, there is a fast and easy way to do auto serial for either the day, month or year in Excel. If you did not know, Excel has a built in feature that tries to anticipate what you are trying to do and will do it automatically for you. This is quite helpful such as in your case where you have to do a lot of typing of data.

Let's say for example, you want to input numbers in a list from 1 to 50. The normal way of doing this would be to input each number in each cell one at a time. This process not only takes you a lot of time to do but can also be quite stressful. The easier method of accomplishing this task is to first make a pattern that you want Excel to follow.

So the first step is to input two numbers, one in each, this will be your pattern. It should look something like this.

The next step is to highlight the numbers starting from the first cell going down to the next. Next thing you have to do is to click on the little square box that can be seen on the lower right hand side of the cells you highlighted. The little square box has been circled in the image below.

  

The last step is to simply drag down until you reach 50 while you click and hold on the little square box. Once completed, you should have something that looks like this.

This process can be repeated when you wish to create lists that are incremental. The days of the week, months, and also years can be done with this technique as well.

    

Hope this helps you out.

About Abigeal

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 09/22/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #122168

Excel: formula to get auto serial, day, month and year

 

I will introduce a formula in order to appear the next day automatically when you enter the next data in the next column.

In the following image I have shown the day 1 and corresponding data.

 

 

 

Now type the following formula in the cell A3 and copy the same formula to the below cells up to maximum you want.

Important: Although you copied the formula in to below cells those cells will be displayed as blanks.

The formula is,

=IF(B3="","",A2+1)

 

 

 

Now when you enter the amount in the next cells in the column B next day will appear according to the serial order.

 

 

 

In the same way you can apply this to months and years.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel