How to make a year-round calendar with excel

Enter a series of dates in the first column cell.

Select date data, right-click and select Copy.

Select cell b 1, click the right mouse button and select the icon, as shown.

Get two columns of data

Select the data in the second column, right-click and select Format Cell.

Select "Custom" under the Numbers tab, enter "aaaa" in the box on the right side of the page (note that this should be in English format), and click "OK" in the lower right corner of the page.

Get the calendar as shown.

Just enter the work item in column C.