How to Add Day to a Date in Microsoft Excel 2016

Microsoft Excel is an important working tool in the Microsoft Office Suite. It is used to organize random data in an appropriate form.

There are many features that can be used in MS Excel including graphical analysis of data using charts, computing the daily office calculations with the help of formulas and to link multiple data entries to each other using different functions of Excel.

This article will guide you to add a day of a month against any Date since January 1, 1900. Following steps will help to accomplish this task.

Click on the Start button and type Excel, open the MS Excel application.

Click on the File and Open the MS Excel file containing dates.

In the top ribbon of MS Excel, click on the Formula button and select Date & Time.

You are now in Date & Time menu, scroll down the menu and select WEEKDAY. Before selecting Weekday, select the appropriate cell in which you want to see the day of the month against the specific date.

As soon as WEEKDAY is selected, a Function Argument window will pop up. In this window, you have to give the address of the Date cell value in Serial Number. Just click at the cell containing date, MS Excel will automatically provide the address in the Serial Number. In MS Excel, Date should be written in mm/dd/yyyy format.

There will be a number ranging 1-7 will appear in front of date cell. This is the Day Number of the week. Sunday is given as the 1 place in MS Excel. Right click on the Day Number and select Format Cells.

In Format Cells window, select Custom option in number category and in Type option, write dddd. This will convert the numeric Day Number to the text form.

Now, drag down the cell with Day Name till the end of the column, All the days will be displayed corresponding to the dates written in the respective cells.

Now you can add days automatically as per dates.

Leave a Reply