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?