To get the weekday of the day after "Feb 13, 2022" in Google Sheets, use: =TEXT(DATEVALUE(TEXT(C4, "mmm dd, yyyy")) + 1, "dddd").
To get the weekday of the day after "Feb 13, 2022" in Google Sheets, use:
=TEXT(DATEVALUE(TEXT(C4, "mmm dd, yyyy")) + 1, "dddd")
.
The +1
adds one day, and TEXT(..., "dddd")
displays the weekday.
For Japanese output, replace "dddd"
with "aaaa"
.
Comments
Post a Comment