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 found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is […]

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 month, etc. See the sheet “Data” for details and table of specific dates and rules. Contact me for more detail

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 that converts a date into its week number, but the reverse is what needed here So after my mouth was drooling while she was asking […]