Hey, I am spamming this forum like crazy... 
One question: Is there any way that the function could look into the cell where the starting date is, and then to return me the the name of that day and dates + for following days, so for all week.
U4, I insert the date, then formula needs to populate row 7,8 (where the days and dates are) for week 1, row 77, 78 for week 2,... So everytime I enter the ştarting date in U4, the days and dates dynamicly changes for all 4 weeks ahead.
For example: I enter 3.11.2014, into U4. In row 7, I have now written mon, tue, wed (because starting day was 3.11 which is monday), and in row 8 I have written dates. The same procedure for week 2, 3, 4 if you scroll down. Is this possible?
Thanks.
Igorsusa
One question: Is there any way that the function could look into the cell where the starting date is, and then to return me the the name of that day and dates + for following days, so for all week.
U4, I insert the date, then formula needs to populate row 7,8 (where the days and dates are) for week 1, row 77, 78 for week 2,... So everytime I enter the ştarting date in U4, the days and dates dynamicly changes for all 4 weeks ahead.
For example: I enter 3.11.2014, into U4. In row 7, I have now written mon, tue, wed (because starting day was 3.11 which is monday), and in row 8 I have written dates. The same procedure for week 2, 3, 4 if you scroll down. Is this possible?
Thanks.
Igorsusa
