Category: DATE

Convert Date/time number from regular number to Unix DateTime Number....

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

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

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded...

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