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?
5 replies on “Neat Microsoft Excel tip”
Nice tip. It works on Google spreadsheets too.
Incidentally, there is a web tool that does the same thing.
Karmadude: yeah man…checked it now..after your alert. It works! So do the other formulae.
Patrix: Thanks mate. Nice site that was…not just the tool…various other uses
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”