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 





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: