Weekday Formula to capture the Tuesday after a date
Hello,
I'm trying to use the Weekday function to add the Tuesday after a date in another cell. I started off with logic if the Weekday is a Sunday (1), then the Start Date should be '+2', but am getting the #Circular Reference error. Can you help?
Best Answer

Hi,
The problem is most likely because the formula is being entered in the same column where the data is being evaluated.
The formula below return the adjusted date, but in a different column.
=IF(WEEKDAY([End Date]@row) = 1, [Start Date]@row + 2)
I hope this helps otherwise hopefully someone else can provide you with a better solution.
Answers

Hi,
The problem is most likely because the formula is being entered in the same column where the data is being evaluated.
The formula below return the adjusted date, but in a different column.
=IF(WEEKDAY([End Date]@row) = 1, [Start Date]@row + 2)
I hope this helps otherwise hopefully someone else can provide you with a better solution.

Yes, that definitely helped. Thanks Jeff!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!