Formula to return the date of the following Friday:
Formula:
=IF(WEEKDAY(TODAY())<=6, TODAY()+7-WEEKDAY(TODAY()), TODAY()+14-WEEKDAY(TODAY()))
Explanation:- The WEEKDAY function returns a number representing the day of the week (1 for Sunday, 2 for Monday, etc.) for a given date.
- The TODAY function returns the current date.
- The IF function checks if the current day (returned by WEEKDAY) is less than or equal to 6 (which means it's not a Saturday or Sunday).
- If it's not a weekend day, the formula adds 7 days (one week) and subtracts the current day of the week (so that it returns the date of the following Friday).
- If it is a weekend day, the formula adds 14 days (two weeks) and subtracts the current day of the week (so that it returns the date of the next Friday).
Simply enter this formula into a cell in Excel, and it will automatically update to show the date of the following Friday based on the current date.