Weekday Formula to capture the Tuesday after a date

Options

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?

image.png


Best Answer

  • Jeff M.
    Jeff M. ✭✭✭
    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

  • Jeff M.
    Jeff M. ✭✭✭
    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.

  • Kerri S
    Kerri S ✭✭

    Yes, that definitely helped. Thanks Jeff!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!