The days of the week in a table
stejamail
Posted messages
6
Status
Membre
-
stejamail Posted messages 6 Status Membre -
stejamail Posted messages 6 Status Membre -
I would like to create a table where, by selecting a day of the week in the first cell using a dropdown menu, the following cells update according to this first cell.
Thank you for your help.
For example, if my first day of the month starts on a Tuesday, the following days automatically fill in until the end of my table.
Thank you!
Thank you for your help.
For example, if my first day of the month starts on a Tuesday, the following days automatically fill in until the end of my table.
Thank you!
2 réponses
Good evening
Enter the first date in cell (A1 for example), e.g. 01/04/2015
Right-click on the cell, go to Format Cells, Custom, and set the type to jjjj to display only the day name
To extend the table, in column A2 enter the formula =A1+1
Drag the formula down the column as needed
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
Enter the first date in cell (A1 for example), e.g. 01/04/2015
Right-click on the cell, go to Format Cells, Custom, and set the type to jjjj to display only the day name
To extend the table, in column A2 enter the formula =A1+1
Drag the formula down the column as needed
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
Cool, my spreadsheet works thanks to you!!!
Thanks to your formula, the weekdays, today's date, and the month in different cells are automatically filled in by selecting the first day of the month we want from a drop-down menu in one cell. Thanks again.
If you have a solution to my second problem: in my spreadsheet, if a cell falls on a Sunday or Saturday, is it possible for the entire row of my table to be filled with a gray color, for example?
Best regards.
stejamail
Assuming the dates are in column A starting from A2, select all the rows from A2 to the last one, then Home Conditional Formatting, New Rule Apply a formula, and enter the formula:
=WEEKDAY($A2,2)>5
before choosing the Format fill of the desired color
Regards
Via