Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 25 Oct 2025 05:05:39 +0000

How to Post a Message for Support

Post From: Study Alert Question

[2020-04-06 12:55:33]
[Go To First Post]
Sawtooth - Posts: 4278
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))