Forum Discussion
setting another excel fields value to give another cell's value
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 ...
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)