How to get nearest dates for tues and fri

[BriGhtZ]

Hi, I am looking for a formula to get the nearest dates for tues and Fri.

Source dates result dates
Monday. -> Tuesday
Tuesday -> Tuesday
Wednesday -> Friday
Thursday -> Friday
Friday -> Friday
Saturday -> Tuesday
Sunday -> Tuesday

 

[BriGhtZ]

Hi, I am looking for a formula to get the next nearest dates for tues and Fri.

Source dates result dates
Monday. -> Tuesday
Tuesday -> Tuesday
Wednesday -> Friday
Thursday -> Friday
Friday -> Friday
Saturday -> Tuesday
Sunday -> Tuesday

 

[felixstraube]

Assuming you have your dates in columna B, starting in B2, try this formula in C2 for example and copy down:

=LET(wd,WEEKDAY(B2,16),IF(wd<5,B2+4-wd,B2+7-wd))

 

[bebo021999]

Suppose your actual date is in A1
It seems like you have 2 working days in week: Tue and Fri (0 in 1011011)

=WORDAY.INTL(A1-1,1,"1011011")

 

[BriGhtZ]

How, I have tested all the codes. It's all working. Thank you

 

[felixstraube]

I didn't know you could use a string like this as the Weekend argument. Nice! Thanks!!!