In Cell A1 I have a date 04/01/19 (this is called Effective Date
In cell B1 I need to return a date that is a Tuesday before the 20th of the month prior to 04/01/19 (this is called Deployment Date)
Also, if the Tuesday is only 2 days before the 20th, it has to go find the next earliest Tuesday.
For example, the output for the 04/01/19 date should be 03/12/19, and not 03/19/19, because the 19th is only 1 day before the 20th.
Bookmarks