LastSunday, LastSaturday
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...
Get 3rd Wednesday of month
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...
Schedule column
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...
SimpleANBox
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...