06/05/2024 | 20:25
Mbbank yên viên
Certainly! You can use the TEXT function in Google Sheets or Microsoft Excel to convert a date into the corresponding weekday name. Here's how you can do it:
In Google Sheets:
Assuming your date is in cell A1, you can use the following formula in another cell to get the weekday name:
```
=TEXT(A1, "dddd")
```
In Microsoft Excel:
Similarly, assuming your date is in cell A1, you can use the following formula in another cell:
```
=TEXT(A1, "dddd")
```
This formula will convert the date in cell A1 into the corresponding weekday name ("Thursday" for example).
4.9/5 (85 votes)
Website