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

Question

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!

Answer 1

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

=TEXT(M4,"dddd")