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