Register

Calculation for a value to show every 10th of the month

neg177
Regular Contributor

Calculation for a value to show every 10th of the month

Hi,

 

We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead. 

1 REPLY 1
TonyViGrand
Occasional Contributor

Re: Calculation for a value to show every 10th of the month

Hi @neg177 

 

I have created a solution with simple test module which will give the 10th day of the month and if 10th is a weekend then it gives the next business day of the month.

TonyViGrand_0-1619264291513.png

TonyViGrand_1-1619264337605.png

TonyViGrand_2-1619264520593.png

 

In case if you are looking for a solution which gives the 10th working day or business day of every month excluding all weekends then the below snip will help you.

TonyViGrand_3-1619264599032.png

 

Hope one of the above solutions will help you.

 

Regards,

Tony Grand