I have probably a very simple question. I have a workbook that keeps track of the sales for the year. There are twelve sheets in the workbook (one for every month). I made the chart I would use in the month of January and just copied/pasted the formatting for the remaining 11 months.
In the DATE column for January you can just type the day your are on (1, 2, 3, 4 etc...) and it would automatically format to become 1/1, 1/2 , 1/3 etc.
The problem is that it keeps the months of JANUARY (1) for all remaining months. How can I change this?
I have tried the date and day formulas but they still show 1/1 or 1/2 (depending on current day) i need it to show 2/1 or 2/2 (same thing for march 3rd month) and (april 4th month).
How do I fix this?
Bookmarks