Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 04:28:41 +0000



Post From: Fridays on Chart

[2023-10-02 04:54:04]
j4ytr4der_ - Posts: 938
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.