![]() Select the Numbers tab in the Format Cells dialog box (if not selected already).This will open the Format Cells dialog box Hold the Control key and press the 1 key (or Command + 1 if using Mac).While this is good enough, I only want to show the day number.īelow are the steps to change the format of the cells to only show the day number from the date value: The result of the formula is the date serial number, so you may either see a serial number (such as 44562) or a date. In case you’re not using Excel for Microsoft 365 or Excel 2021, you can use the below formula instead: =IF(MONTH(DATE($B$1,$N$4,1)+(ROW()-5) 7+COLUMN()-3-$N$5)=$N$4,DATE($B$1,$N$4,1)+(ROW()-5)7+COLUMN()-3-$N$5,"")Įnter this formula in cell D5, and then copy and paste it for all the other cells in the calendar grid. ![]() This is because it uses the SEQUENCE function, which is a new formula and is not available in the older version of Excel. Note: This formula would only work in Excel for Microsoft 365, Excel 2021, and Excel for the web.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |