Forum Discussion
I need a help with a formula
Hi,
I want C4:F4 to be automatically calculated based on the week number.
For example, it needs to be shipped out on 11/20 to arrive in week 1 of December.
11/27 for week 2, 12/4 for week 3 of December, and so on.
I think I should input Cell C3 as 2020/12/01 and display it as week1, but I can't really figure it out.
I'm not sure if my explanation makes sense...but please help if there is a way that works out!
As variant
if in C1 first date of the month, and in D1 delivery time (11 days), when
- in D1 just =C1, apply custom mmmm format and align C2:F2 with Center Across Selection
- in C3 is 1, in D3 =C3+1, etc and apply custom number format "week "0 to C3:F3
- in C4
=$C$1+(C3-1)*7-11and drag it to the right
3 Replies
Hi,
I need to calculate B2, not B1.
on Cell B1, I can just put week1, but I thought it needed to be shown as the date in order to calculate Cell B2.
As variant
if in C1 first date of the month, and in D1 delivery time (11 days), when
- in D1 just =C1, apply custom mmmm format and align C2:F2 with Center Across Selection
- in C3 is 1, in D3 =C3+1, etc and apply custom number format "week "0 to C3:F3
- in C4
=$C$1+(C3-1)*7-11and drag it to the right
