[Affiliate]
Blog Stats
- 3,191,133 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to replace value with a value from another column in Power Query
- Show number in thousand (k) or in million (M) by using custom format
- Open an embedded Excel file during a slide show in PowerPoint?
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Lovely stickers in #Excel 365
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Calculating CAGR with Goal Seek in #Excel
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: MIN
Determine leap year with #Excel
Today is a special day. Today is February 29th, which happens only once every four years. And today is Saturday, when I usually post a new blog. So let’s talk about how to determine if a year is leap year using … Continue reading
Using MIN/MAX to answer whichever lower/higher questions
What is “Whichever higher”? Situation: You call to your favourite restaurant to reserve a private room for family dinner on Saturday. The restaurant manager tells you that there will be a minimum charge of $2000 for a private room. That mean, … Continue reading
How to calculate number of overlapping days for two periods?
Have you ever encountered a situation that you need to find out how many days in Period 2 fall into Period 1? Is using IF(IF…(IF…(IF…(IF….. the first thing in your mind?
How Excel formula can save your time?
Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example. I was … Continue reading