what are the steps to generate week days in MS EXCEL
Answers
Answered by
1
In Microsoft Office Excel 2007, follow these steps:In the cell that you want to return the day of the week, type =A1, and then press ENTER.Select the cell with the returned date.Click the Home tab.Click Format Cells: Number in the Number group. This will open the Format Cells dialog box.On the Number tab, click
Date, and then select the date format that contains the day of the week in the Typelist.Click OK to close the Format Cells dialog box.In Microsoft Office Excel 2003 and earlier versions of Excel, follow these steps:In the cell that you want to return the day of the week, type =A1, and then press ENTER.Select the cell that has the returned date.On the Format menu, click
Cells.On the Number tab, click
Date, and then select the date format that contains the day of the week in the Typelist.Click OK to close the Format Cells dialog box.
Date, and then select the date format that contains the day of the week in the Typelist.Click OK to close the Format Cells dialog box.In Microsoft Office Excel 2003 and earlier versions of Excel, follow these steps:In the cell that you want to return the day of the week, type =A1, and then press ENTER.Select the cell that has the returned date.On the Format menu, click
Cells.On the Number tab, click
Date, and then select the date format that contains the day of the week in the Typelist.Click OK to close the Format Cells dialog box.
Similar questions