Weekday Formula to capture the Tuesday after a date

Kerri S

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?

Jeff M.

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.

Jeff M.

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

Yes, that definitely helped. Thanks Jeff!