Date formula reoccurring on a specific day of week

Morris R

Hello

Requesting a formula (column) to return a date to a specific week but is always on a Tuesday.

My spreadsheet is a work back schedule to a specific date.

Launch date occurs on any day of the week but I need minus 3 weeks to land on Tuesdays.

Thank you

Paul Newcome

Give this a try:

=([Date Column Name]@row + (3 - WEEKDAY([Date Column Name]@row)) - IF(WEEKDAY([Date Column Name]@row) < 3, 7, 0)) - 28

Paul Newcome

Are you able to provide some screenshots for context?

Morris R

Thank you in advance

I would like the PERMIT column (if possible) to occur on TUESDAYS minus 4 weeks from LIVE date.

Currently using a simple formula =LIVE@row - 28

Paul Newcome

Give this a try:

=([Date Column Name]@row + (3 - WEEKDAY([Date Column Name]@row)) - IF(WEEKDAY([Date Column Name]@row) < 3, 7, 0)) - 28

Morris R

Worked perfectly

Thank you !

Paul Newcome

Happy to help. 👍️