Support Board
Date/Time: Sat, 05 Jul 2025 02:29:34 +0000
Post From: Study Alert Question
| [2020-04-06 12:55:33] |
| Sawtooth - Posts: 4232 |
|
This returns the week number of the 1st of the month, and its value is persistent until the 1st of the subsequent month: WEEKNUM(DATE(YEAR(BARDATE),MONTH(BARDATE),1)) So to get the 1st week of the month, compare it to the previous bar: =WEEKNUM(DATE(YEAR(BARDATE),MONTH(BARDATE),1))<>WEEKNUM(DATE(YEAR(BARDATE[-1]),MONTH(BARDATE[-1]),1)) The spreadsheet formula would look like this: =WEEKNUM(DATE(YEAR(A3),MONTH(A3),1))<>WEEKNUM(DATE(YEAR(A4),MONTH(A4),1)) |