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