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 on what is the formula …
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 holidays is defined in another …
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 with technology (since 1997) I …
Expenses calendar, FaCal
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 your bills Refreshes every time …
Custom fiscal year calendar (CFlex)
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 workday after 15th of each …
Week number to Month number
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 week number is in A5, …
Week number to Sunday date – Weeknum reverse
This was a request from one of my work managers She wanted to convert a week number she got in a column into thier dates Excel already have the WEEKNUM …