Apply conditional formatting to highlight weekdays after a 7-day interval in Google Sheets

Other Questions Google Sheets
1

I’m looking to create a custom formula in Google Sheets that highlights a cell when it has been 7 working days from a specific date, excluding weekends. Here’s my initial formula:

=TODAY()>=WEEKDAY($E8+7)

I also tried using the NETWORKDAYS function, but it didn’t yield the desired result. Can anyone provide insights or suggestions?

2

Hey, try using this formula for conditional formatting: =NETWORKDAYS($E$8, TODAY()) = 7. This shld highlight the cells exactly 7 workdays frm the given date, ignoring weekends effectively. Hope it helps!