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 - Month - Day - Year
So it would look like this:
Monday, January 1, 2018 and so on for EVERY day of 2018.
Is there a function or formula that I can put in to my excel sheet so I don't have to manual type in every day of the week and date for every day of 2018? Thank you in advance.
4 Replies
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.
