Monthly Archives: October 2014

Trick or Treat 2014

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?

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

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

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?

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