google-sheets

How to code "Next Friday" in Google Sheets?

I would have thought that =TODAY() + (6 - WEEKDAY(TODAY())) would work, but there is an bug in here somewhere.

The above still shows 5/21. (Previous Friday)

Thanks!

Solution

  • I ended up using a switch statement. Ugly, but it works

    =TODAY() + SWITCH(weekday(today()), 7,6,6,7,5,1,4,2,3,3,2,4,1,5)