Login Page - Create Account

Support Board


Date/Time: Thu, 22 May 2025 20:31:48 +0000



Post From: Fridays on Chart

[2023-10-02 04:54:04]
j4ytr4der_ - Posts: 947
In case someone else comes across this and is thrown for a loop... with the WEEKDAY function, 0 is not Sunday, 1 is Sunday.

https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function

Returns an integer representing the day of the week for the given Serial DateTime Value. The return value will be in the range of 1-7 (1=Sunday, 7=Saturday). Returns #VALUE! if the given DateTime cannot be interpreted as a serial date value.