Neat Microsoft Excel tip

Excel has a nice feature which counts the number of days between two dates. For example, if I wanted to find how how long I have been blogging, all I need to do is go to a cell and type:

=”04/21/2007″-“08/10/2003”

First I mention today’s date…and then the date I started blogging. When I press ‘enter’…the cell will display ‘1350’! Yes, thats the number of days I have been a blogger. Awesome, isn’t it?

By Jamshed V Rajan

Jammy, as Jamshed V Rajan is affectionately called, is a wannabe stand up comedian. He has a funny take on most things but documents only some of them. If you are interested in chatting up with him, do drop him an email at jv.rajan@gmail.com or message him at +919650080255.

5 replies on “Neat Microsoft Excel tip”

the easier way is click on the cell and type in =today() – (your desired date). of course if it shows jumbled charecters or some nonsense, just right click on the cell and click on “format cells” and change the type to “date” or “time”

Leave a Reply

Your email address will not be published. Required fields are marked *