Category: WEEKDAY

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

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

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

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

Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on...

Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st...

Now we need to convert week number to month number This is exactly the same as week number to date (reverse weeknum) So, when the...