How to calculate n-th day of week in month (and other spreadsheet date functions)

How To
,
1

Good morning Makers! Having some challenges getting the n-th day of week in month example to work (Help Link). Hoping some of you have a collection of simple to use examples of date functions and solutions for common spreadsheet date functions that you are willing to share.

Regards
Ockert

2

Hello @OckertCameron

or check DOW Tokens for date/time parsing Help Docs | Integromat Help Center

3

Thank you Sebastian.

Hoping someone has used the internal functions, do not have the financial resources for external services.

Regards
Ockert.

4

Heya @OckertCameron welcome to the community :wave:

Maybe this article could point you in the right direction: 🧠 [Tip] Schedule scenarios to run on the last day of the month.

5

Thanxs Michaela,

Below is the current Google Sheet formula i am trying to encode in Make.

=WORKDAY.INTL(EOMONTH($C2,0),$A2,REPLACE(“1111111”,MATCH(left($B2,3),{“Mon”,“Tue”,“Wed”,“Thu”,“Fri”,“Sat”,“Sun”},0),1,0))
$A2 = nThDayFlag
$B2 = day of the week in text
$C2 = start contract date

Delivery contracts can be specified for a customer as:

  1. Start of the Delivery Cycle (date);
  2. Customer receive frozen goods on the 2nd Tuesday of the month as of the Start Delivery cycle.

Regards
Ockert

6

Hi @OckertCameron ,

Do you mean by “n-th day of week in month” something like “3rd Monday of May”? Or do you just want to know the day in the week? Like Monday?
Just double checking so I know what your expected outcome is.

Glenn - Callinetic

1 Like
7

Hi Glenn,

The “3rd Monday of the next month” is what I am trying to encode.

Some background - we operate a specialised frozen goods courier service in Gauteng province, South Africa. Several of our customers have repeat / subscription customers, that we deliver to on their behalf. We are automating reminders and scheduling of these repeat customers to help with out own planning and forecasting.

Regards
Ockert.

8

Hi Ockert,

I shared a showcase recently that may help. My purpose is very different so it would require some customization from you, but maybe you can glean some valuable information from my shared solution?

Hope this helps!
-Joe

1 Like