Feb 09 2021 06:47 AM
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
Feb 09 2021 07:24 AM
@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)