Hi Sudhir,
Simply use Subtraction Operator.i.e. Hyphen(-) to do this. For e.g. if A1 is 1/12/2010 and B1 is 31/12/2010, then formula would be B1-A1+1 to calculate the total days between two dates. PS: If you need business working days, then use NETWORKDAYS(A1,B1) to calculate working days between 2 dates :) To see 19 examples of all types on OFFSET Function, click here.<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html> ------------------------------ Excel VBA Interview Questions<http://www.excelitems.com/2010/12/excel-vba-interview-questions.html> Collection of Excel VBA Macros<http://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html> VLOOKUP<http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html> OFFSET<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more> ARRAY formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html> ------------------------------ Excel 2003 Style Menu in Excel 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> Custom Number Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html> CONTACT a TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html> ------------------------------ Thanks & Regards ------------------------------ Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com Facebook <http://www.facebook.com/eXceLiTems> Twitter<http://www.twitter.com/eXceLiTems> LinkedIn <http://in.linkedin.com/in/ashishjain08> LiveJournal<http://livejournal.excelitems.com/> Digg <http://digg.com/excelitems> Delicious<http://www.delicious.com/save?new=1&url=http%3A%2F%2Fwww.excelitems.com%2F&title=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloads&type=BOOKMARK&jump=http://www.delicious.com%2Fmountint&key=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-©user=mountint&via=mountint©tags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com> Subscribe to Email<http://feedburner.google.com/fb/a/mailverify?uri=excelitems> ------------------------------ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
