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
Check out the Formula Handbook template!