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

Answer 1 / 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
Smiir Posted messages 6 Status Member
 
I would like to make the autofill based on the start and end dates:
0
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
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
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