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...
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...
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...
Highlight dates dynamically
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it...
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...
Calculate hours between two cells
We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others...
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...