G66
Reputation: 1
google sheets - changing a cell text based on another cell which has a date of my choosing
I have a column A1:A100 which all cells are a list of the days of the month. one the other column B1:B100 I want to say which day of the week the text on A column is.
tried this:
=IF(A2="01/04/2021"; "thursday"; "")
cant make it work for more 29 options
I need some help here
Have a nice weekend
Upvotes: 0
Views: 59
Answers (1)
Adam Stevenson
Reputation: 727
Try the WEEKDAY function and wrap it in the TEXT function:
=TEXT(WEEKDAY("01/04/2021", 1), "dddd")
Upvotes: 3
Related Questions
- Generate formula for compare dates and if condition is met, put custom text
- Set dates in range dependent on first date of range
- Array Formulas - Multiple IF scenarios / Difference between Dates
- How can i change text depending on the date in another cell Spreadsheets
- Google Sheets or Excel Function to return date based on value
- Updating array formula syntax to change reference date
- Comparing two dates in array based on criteria in Excel
- changing array in excel based on another cell
- Display Specific Text based on cell value (Date)
- Microsoft Excel Array Formula with dates