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 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:
=L2+7-WEEKDAY(L2,2)
