How to get the first, fifth and ninth business day of the month?

AppSheet AppSheet Q&A
,
1

I’d like to email my app users on the first, fifth, and ninth business days of the month. Looking in the documentation I found the WORKDAY function, but I’m having trouble creating this logic. Does anyone have any tips or know a way to build this logic?

Thanks!!!

2

I’m not experienced using the WORKDAY() function, but I looked it up and think the following should provide what you need.

First business day:

WORKDAY(
	DATE(
  	CONCATENATE(MONTH(TODAY()), "/1/", YEAR(TODAY()))
    ), 
  0)

Fifth business day:

WORKDAY(
	DATE(
  	CONCATENATE(MONTH(TODAY()), "/1/", YEAR(TODAY()))
    ), 
  4)

Ninth business day:

WORKDAY(
	DATE(
  	CONCATENATE(MONTH(TODAY()), "/1/", YEAR(TODAY()))
    ), 
  8 )
2 Likes
3

Thank you!!!

1 Like
4

This:

(EOMONTH(TODAY(), -1) + 1)

is equivalent to:

DATE(
CONCATENATE(MONTH(TODAY()), "/1/", YEAR(TODAY()))
)
1 Like