Connecting Technology and Business.

How many number of days have you walked on earth?

​Do you know how many days it has been since you started walking on this earth? (Make sure you subtract the days when you were, as a baby, being held by somebody or you were just crawling, from the result, if you want a more accurate answer)

Excel contains a function datedif() that will give you exactly this number. Here is how it is used...

Enter your birth date in cell A1

Choose another cell and enter the formula =DATEDIF(A1,TODAY(),"d").

You will see the number of days displayed in the cell.

You can also use "m" in the place of "d" for the number of months and "y" in the place of "d" for the number of years.

You can also find out the number of days you have put in your current company (or past), the number of days you were working on a certain project (Week ends, Sundays and holidays are included here) and the number of days you have known a certain person, or just the number of days between any two dates.

How many days has the Earth borne your weight so far?

Assign Offs for your staff scientifically!

If you are working in an organization that allows an off day during the week (apart from a Sunday which is a holiday, in most cases) and you want to assign offs for your staff, you might face a difficulty of choosing these off days for the staff if this assignment is done by you manually. There is also a complaint of favaouritism against you by the staff, some times. There is also the human tendency to repeat numbers in a certain sequence in such cases. As a result, you might also overload a day with many staff offs or underload a day with few staff offs. 

You can do a scientifical assignment of these offs using an excel function randbetween(). Here is how it is used...

RANDBETWEEN() function takes two arguments inside the brackets and then generates a random number.

If we assign 1 for Sunday, 2 for Monday and so on till Saturday is assigned 7, then we can make use of the random number generator.

We enter the names of staff in one column and place the function in the adjascent column. The formula in the cells would be =randbetween(1,8). You can place this formula in the cell at the top of the column that requires this Offs assignment information and then drag it till the last cell (or just a double click from the bottom right corner of the first cell). Now, all 2s stand for Monday off, 3s for Tuesday off and so on.

Filter mails addressed to you only using a Search folder in Outlook 2010

Have you ever wanted to filter all emails that were addressed to you only so that you can pay your first attention to these mails? You can create a Search folder for this. A search folder is a virtual folder. Outlook will not transfer or duplicate a mail from its original location, whether in the Inbox or in named folders, into the search folder.

 Here is how it is done:


Under the Folder tab in Outlook, click on New Search Folder.


 Search folders pic1.jpg


Select “Create a custom Search Folder” and name it as “Only to me” (or any other comfortable name).
Check the box: Where I am the only person on the To line.


Search Folders pic2.jpg
That is all. All mails addressed only to me will be visible in this folder. If you go to “more choices”, you can also choose “unread mail” option.