smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells.
I need formula to convert those "dates" into weekday name. Coverted results should be in column B (B1:B600).
example.
<tbody>
</tbody>
In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells.
I need formula to convert those "dates" into weekday name. Coverted results should be in column B (B1:B600).
example.
A | B | |
1 | 04.10.2019 - 20:00 | Fri |
2 | 04.10.2019 - 22:30 | Fri |
3 | 05.10.2019 - 16:00 | Sat |
4 | 06.10.2019 - 12:45 | Sun |
5 | 07.10.2019 - 18:00 | Mon |
6 | .... | .... |
<tbody>
</tbody>
Last edited: