question by: Patrick Lathrop
Last (weekday) of following month formula for creating payment schedules?
So, with a little help from the help community i was able to put together an Nth day occurrence script that cleverly determines the weekday associated with an original date (S3) and then counts the number of days in the current month to produce an accurate 1st 2nd 3rd or 4th (weekday) occurrence.
Unfortunately this clever bit of work, while accurate up to 2102 in my testing for 1st~4th occurrences gets broken by people who are assigned a last (weekday) of month schedule.
The current formula is as follows:
Is there a clever way to retrofit this formula to work with a LAST (weekday) payment schedule? Or an easier way to make a separate formula to detect the weekday and display the last weekday of the following month?
As example 7/31 (TUESDAY) and display 8/28/18 aka the last Tuesday of august 2018?
I'm including a copy of the spreadsheet i'm working on for reference, any and all help is greatly appreciated.