setting another excel fields value to give another cell's value

Occasional Visitor

Hi i want one field to autofill with a set answer when i input another field's data.

in this example i want the date field to fill the week field, how can i set this? 

 

do i require a VLOOKUP of value from another tab or can i set it by calendar date 

 

cmckernan93_2-1612881998132.png

 

 

1 Reply

@cmckernan93 Don't see the row number where you want to put the first formula, but suppose that the first formula will be in J2. Then try this:

=L2+7-WEEKDAY(L2,2)