# Forcing a specific day of week of workback

Hi! I am setting up a workback subtracting days from a date based on dependancies and used the hidden formula from The Monday Man which worked AWESOME! but I would like to take it one step further if possible. Two of my tasks MUST fall on a Tuesday - The brief date and the creative presentation date. Is there a way in the network days formula to force that. Not ALL days must be a Tuesday, just 2 in a list of 20.

Given his stellar expertise on this one, I might involve the monday man himself! Hey @JCorrell What are your thoughts on taking the formula a step further? I will raise this with our internal formula team too to investigate

Hi Sheri,

If you want to get the first Tuesday after a specific date, you can use this formula:

``````FORMAT_DATE(ADD_DAYS({Date},ADD(MINUS(2,WEEKDAY({Date},1)),IF(WEEKDAY({Date},1)>2,7,0))),"YYYY-MM-DD")
``````
• WEEKDAY({Date},1) returns the day of the week of your date (Monday: 1, Tuesday: 2)
• MINUS(2,WEEKDAY({Date},1)) calculates the difference in days between the date and the next Tuesday. If the date is already Tuesday, this part becomes 0.
• IF(WEEKDAY({Date}, 1)>2,7,0) checks if the given date is after Tuesday. If it is, it adds 7 days to move to the next week’s Tuesday.

So

• ADD(MINUS(2,WEEKDAY({Date},1)),IF(WEEKDAY({Date},1)>2, 7, 0)) gives you the number of days that needs to be added to get to the next Tuesday.