How to get the Date for each Friday

[Quality_Assuran]

Hi community

I want to have a form thats start date is every Friday.

I have a column saving the WEEKNUM.

How can I get the date of each Friday using WEEKNUM and WEEKDAY?

[Aurelien]

Hi @Quality_Assuran 

Does these examples help you?

EOWEEK() - AppSheet Help

[diogolupcosta]

Set this as formula of initial value in start date

IFS(
WEEKDAY(TODAY()) = 1, TODAY() + 5,
WEEKDAY(TODAY()) = 2, TODAY() + 4,
WEEKDAY(TODAY()) = 3, TODAY() + 3,
WEEKDAY(TODAY()) = 4, TODAY() + 4,
WEEKDAY(TODAY()) = 5, TODAY() + 5,
WEEKDAY(TODAY()) = 6, TODAY(),
WEEKDAY(TODAY()) = 7, TODAY() - 1
)