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

[Henrique_Vieir2]

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!!!

[dbaum · Accepted solution]

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 )

[Steve]

This:

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

is equivalent to:

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

[Henrique_Vieir2]

Thank you!!!