Forum Discussion
office
Nov 14, 2017Copper Contributor
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...
SergeiBaklan
Nov 14, 2017Diamond Contributor
You may apply format
dddd, mmmm dd, yyyy
to the cells with your dates
office
Nov 14, 2017Copper Contributor
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?