Need a VLOOKUP?

Julien Lopez

Hi

based on the table, i'm looking for a formulas that can check the box in column yellow. the logical is:

within the same week:

IF i'm IN on the weekend, i need to be OFF on the days listed in the column "Congé de semaine" (week of 12-may-2025).

IF i'm OFF on the weekend, i need to be IN the rest of the week (week of 5-may-2025)

i will add a formulas to manage the IN/OFF in the column Days IN if column 1 is tick or not (there are others columns in the sheet linked to this rule)

thank you for your help

prime_nathaniel

Julien Lopez

Use = week(date) to get the week of the date
Use = weekday(date) to determine what day your date is
add if(test, true, false) for OR(weekday(date)=1, weekday(date) =7), which is sunday or saturday

You should now be able to write your in thens to match your use case