View original (French)

The days of the week in a table

stejamail Posted messages 6 Status Member -  
stejamail Posted messages 6 Status Member -
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!

2 answers

  1.
    via55 Posted messages 14395 Registration date   Status Member Last intervention   2 759
     
    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
    1
    1. stejamail Posted messages 6 Status Member
       
      Thank you for your response.
      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
      0
    2. via55 Posted messages 14395 Registration date   Status Member Last intervention   2 759 > stejamail Posted messages 6 Status Member
       
      Re,

      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
      0