Neat Microsoft Excel tip
If you're new here, you may want to subscribe to my Blog's RSS Feed. Or my Comment's RSS Feed. Your funny bone is definitely as big as your femur!
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?
(No Ratings Yet)
Loading ...
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”
Leave your response!
Today's Poll
Twitter Updates
Most Recent Comments
Tag Cloud on Ouchmytoe.com
Baby Baby Daughter Bachelor Birthday Blogging Ceremonies Childhood Current Affairs Dance Daughter Driving Family Father Father-in-law Girlfriend Google Gurgaon Hangover Husband Islam Jaipur Joke Love Marriage Mobile Mother Mother-in-law Movies Pizza Plugins Porn ProBlogger Reliance Super Religion SEO Sex South India Taslima Nasreen Tea tonsure Wife Woman Wordpress WriterCategories
Bloggers
Archives
About Jamshed V Rajan
He is online 18 hours a day. Chat with him on jv.rajan[@]gmail.com or call him on 09971996581.
On Linkedin | On FaceBook | On ibibo
Highest Rated
Most Commented
Most Viewed