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 up inside Conditional formatting, can …
Category: Date and Time
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 …
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 to help So, when A1 …
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, …
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 …