CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaweekday
Davidator
Davidator

Reputation: 13

Google Sheets how to use two formulas and get one result in a cell

I need to use two formulas in a cell and get only one result.

These are the formulas that I need to combine:

  1. =WEEKDAY(M4) - in M4 there's the date (example: 20-October-2023)
  2. =IFS(M11=2; "Lunedi"; M11=3; "Martedi")

Week days in Google Sheets are given by the formula in numbers (1,2,3 etc.). I don't need to see the numbers in any cell but directly the name of the day.

Is this possible? Thanks!

Upvotes: -1

Views: 130

Answers (1)

Harun24hr
Harun24hr

Reputation: 37125

You do not need two formula. Use TEXT() function. Try-

=TEXT(M4,"dddd")

enter image description here

Upvotes: 0

Related Questions