Auto Update Single Cell Date, Based on Week

[EvilHidden]

Hi,

Looking for a formula that will update itself to show a date - every other Friday.

Detail
We do timecards every 2 weeks, on Friday. We have a database of employees and we need a single cell in their row to update to the next timecard date. So, if today is 7/19/22, the date should be 7/22/22. Once 7/22/22 passes, it should update to 8/5/22. This needs to occur in itself. We cannot reference a list of dates in other cells.

Any way to make this happen?

[Gregb11]

try this:

=TODAY()+7-WEEKDAY(TODAY(),16)

[EvilHidden]

That's amazing.

If I wanted to change the week offset to start on 7/29, I'm assuming I'd just change the 7 to 14?

[Gregb11]

That should work.