Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 26 Nov 2024 02:42:23 +0000

How to Post a Message for Support

Post From: Automatic date exclusion of Rollover week from Charts

[2024-01-28 02:17:20]
[Go To First Post]
Sawtooth - Posts: 4120
This will return the week number in each month:
=WEEKNUM(A3)-WEEKNUM(DATE(YEAR(A3),MONTH(A3),1))+1

This will return the month of the year:
=MONTH(A3)

This will return TRUE in the 3rd week of the months of Mar, Jun, Sep, Dec:
=AND(OR(MONTH(A3)=3,MONTH(A3)=6,MONTH(A3)=9,MONTH(A3)=12),WEEKNUM(A3)-WEEKNUM(DATE(YEAR(A3),MONTH(A3),1))+1=3)