Monthly Archives: October 2014

Trick or Treat 2014

Posted on October 31, 2014 by MF

Today is Halloween.  Let’s do some funny things today. Have you ever thought about to turn your screen upside down?  To do this, you just need to press CTRL + ALT +↓  

Rate this:

Posted in General | Tagged | 2 Comments

How to calculate number of overlapping days for two periods?

Posted on October 25, 2014 by MF

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?

Rate this:

Posted in Formula | Tagged , , | 10 Comments

Advantages of having date input correctly in Excel

Posted on October 19, 2014 by MF

In previous posts, what do we need to know about inputting date in Excel was discussed.  Suggested solutions for fixing trouble dates were also given.  But WHY having date input correctly in Excel is so important? Why should we care? Answer: It’s … Continue reading →

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 1 Comment

Fixing trouble dates

Posted on October 12, 2014 by MF

Different ways to convert dates stored as text or other unrecognized date formats to real dates in Excel. From time to time, we work with dates in Excel files.  Well, if dates were input correctly as serial number, everyone is happy. … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

What we need to know about inputting Date in Excel?

Posted on October 3, 2014 by MF

When you type “1/5/2015” into Excel, do you know whether it is “1st of May, 2015” or “5th of January, 2015”? The answer: It depends! Depends on what?  

Rate this:

Posted in Excel Basic | Tagged | 1 Comment