View original (French)

Filling cells based on a given date

Smiir Posted messages 6 Status Member -  
fabien25000 Posted messages 697 Status Member -
Hello everyone,

I have a schedule with a two-way table. On the horizontal axis, I provide the start date and the end date of the task.
On the vertical axis, I fill the cells based on the dates I have previously entered.

Thus, to speed things up and optimize the workbook, I am looking to automatically fill the cells based on the dates I provide. Is this possible? If so, please let me know how to do it as I am a bit lost with all the Excel features ^^

Thank you in advance for any help you can provide.

1 answer

  1.
    fabien25000 Posted messages 697 Status Member 59
     
    Hello,

    a “=IF” should be enough... Without more information, it’s hard to say more...

    --
    When you only have a hammer, all problems look like a nail.
    0
    1. Smiir Posted messages 6 Status Member
       
      I would like to make the autofill based on the start and end dates:
      0
    2. fabien25000 Posted messages 697 Status Member 59
       
      ok so it's a conditional formatting... your example makes no sense
      from 09/10 to 10/12 there are 5 weeks and 6 cells are formatted?!
      from 09/10 to 09/21 it makes 2 weeks but only 1 cell is formatted... and I'm not even talking about the lines that follow...
      0
    3. Smiir Posted messages 6 Status Member
       
      Yes, I know, it's just an "illustration" to contextualize what I'm asking. The other lines should not be taken into account...
      0
    4. fabien25000 Posted messages 697 Status Member 59
       
      In its current state, I don't think the table is suitable. How do I ask Excel to go to the second week 1?
      The table needs to be revised to align the start and end dates with the week columns.
      0