Forum Discussion
DATES FOR A NEW YEAR ON AN EXCEL SHEET
I am creating a spreadsheet scheduling book for 2018 that I will need to print off for my job. I need to have a scheduling sheet for every day of the 2018 year in this format: Day of the week - Mon...
You may apply format
dddd, mmmm dd, yyyy
to the cells with your dates
Thank you for the help. I don't think I am understanding your assistance.....
The cell is current blank.....
I want the cell, C1, to have: Monday, 01/01/2018 in it. In the same cell, for 264 more days, I want the next consecutive date to automatically appear. Is that possible?
Office,
enter 01/01/2018 in C1.
Enter =C1+1 in C2 and copy the formula down.
And before copying (or Right mouse->Fill days) better to apply needed format to C1
