ThanksgivingDateUSA ( yr )

For a given year, returns the date of the 4th Thursday in November.

Be the first to rate this function Log in to vote

L. Allen Poole - Show more from this author
Creative Database Solutions NW
http://cdsnw.com

Sample input:

ThanksgivingDateUSA ( 2025 )

Sample output:

11 / 27 / 2025

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// L. Allen Poole — allen@cdsnw.com — October 2025

Let ( [
  ~dw = DayOfWeek ( Date ( 11 ; 1 ; yr ) )
; ~dt = 
	Case  ( 
	  ~dw = 5 ; 22 // earliest when Nov. starts on a Thursday
	; ~dw = 6 ; 28
	; ~dw = 7 ; 27
	; ~dw = 1 ; 26
	; ~dw = 2 ; 25
	; ~dw = 3 ; 24
	; 23 )
] ;

Date ( 11 ; ~dt ; yr )
)

The DayOfWeek function gives us what we need to know: knowing what day November starts on predicts the date of the 4th Thursday.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ThanksgivingDateUSA ( yr )

Comments

Support this website.

Support this website.