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.
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:
Start of the Delivery Cycle (date);
Customer receive frozen goods on the 2nd Tuesday of the month as of the Start Delivery cycle.
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.
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.
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?