Support Board
Date/Time: Sat, 28 Dec 2024 09:23:01 +0000
spreadsheet study - day of the week
View Count: 1378
| [2016-04-20 08:18:52] |
| User852906 - Posts: 3 |
|
Hi, in the spreadsheet study, I would like to display the day of the week. could be in numbers or letters, eg monday = 1, tuesday = 2 but preferably letters. I didn't manage to display this with the functions DATE and DAY that I've found thanks very much |
| [2016-04-20 13:14:22] |
| Sawtooth - Posts: 4143 |
|
Use the WEEKDAY function, e.g.: =WEEKDAY(A3) |
| [2016-04-20 17:34:43] |
| |
|
For future reference: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: