Example: in a list display only the first day of the month Sometimes you have alist with dates or other stuff under one another. But you want to see only the first one to make the whole more readable. Looking at the following example. Now create the in the B and C columns the following formulas. B: = MONTH(B4) C: =IF(B4=B3,1,0) The column B and C will later be hidden. Like following Now you have to use conditional formating and create a new rule. Before select the column A. Here it is in RED for the example but if you want to make it disappear, then select the font to be White. like here That's it. Now just hide the B and C column by selecting them at the top and right click and select HIDE. et VOILA. You can download this example here. If you want to have the date horizontaly and have thin excel columns, then you can follow this example.