Forum Discussion

JustStartingFormula's avatar
JustStartingFormula
Copper Contributor
Feb 28, 2024

Formula - weekday help

What I am looking to do is if in Column A: lists duties needed to be performed, Column B: list day of the week an item is due  column E: show duties due for the day of the week (ie. Wednesday, and...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 28, 2024

JustStartingFormula 

To achieve what you described, you can use the WEEKDAY function along with IF or FILTER function in Google Sheets. Here's how you can do it:

In cell E1, you can enter the following formula to display the duties due for the current day:

Googlesheet =FILTER(A:A, WEEKDAY(B:B) = WEEKDAY(TODAY()))

Excel worksheet =IF(WEEKDAY(TODAY(),1) = B2, A2, "")

This formula uses the FILTER function to filter the duties in column A based on the condition that the day of the week in column B matches the current day of the week (determined by the TODAY() function).

Here's how the formula works:

  • WEEKDAY(B:B) returns the day of the week for each date in column B. For example, Sunday is 1, Monday is 2, and so on.
  • WEEKDAY(TODAY()) returns the day of the week for the current date.
  • The FILTER function filters the duties in column A based on the condition that the day of the week in column B matches the current day of the week.

This formula will dynamically update to show the duties due for the current day whenever the sheet is opened or refreshed.

You can place this formula in cell E1 of your Google Sheets document, and it will display the duties due for the current day based on the data in columns A and B. The text was created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

Resources