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?

Uncategorized

5 thoughts on “Neat Microsoft Excel tip

  1. 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 *