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 …
Looplist – Repeating months using formulas
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps …
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 …
Get monthly total from table with dates
Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded interesting in getting this example …
Workdays – Across months
Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the …
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, …