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

  • 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!