Excel f(x)s = Excel Functions
Get the date of the most recent SUNDAY for a specific date:D12 is the cell containing the date =D12 – WEEKDAY(D12) + 1 While Saturday is easier Get the date of the most recent SATURDAY for a specific date: =D12 – WEEKDAY(D12)
This was an interesting request.
Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions.
So, sharing here on what is the formula and how to get there.
Create list of dates excluding weekends and holidays.
Basically create list of workdays in a certain year, you may fill in to get more.
List of holidays is defined in another column, formula already excludes Saturdays and Sundays.
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output.
During my time with technology (since 1997) I found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is the core to it.
