Support Board
Date/Time: Sun, 08 Sep 2024 01:48:22 +0000
Post From: Trading day of month (TDOM) formula
[2024-05-22 14:21:40] |
Sawtooth - Posts: 4083 |
=WORKDAY(EOMONTH(A3,-1),22) returns the 22nd workday of the month, assuming M-F workdays. It returns the incorrect day if there are less than 22 workdays in a month, like in February. Also, you must include a list of holiday dates for the WORKDAY function to not count holidays as workdays. So it's possible to find a certain trading day of the month, but it's not straightforward. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WORKDAY_Function =WORKDAY(EOMONTH(A3,0) +1,-1) returns the last workday of the month. To find the last trading day of the month, you'd need to include a list of holiday dates. |