Dear Sudhir, Just would like to mention that the cells should be in date format, only then this function will work.
Regards, Anubhav On Wed, Jan 19, 2011 at 2:59 PM, Manoj kumar <manoj.vishwakarma...@gmail.com > wrote: > use either of them :- > > =(B1-A1)+1 > =DATEDIF(A1,B1,"d")+1 > > > Regards, > Manoj Kumar > > > On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar <bluecore...@gmail.com>wrote: > >> Hi >> >> All Dear members >> >> Plz help on the following point. >> >> I want count no. of Days between two Dates. >> >> Example >> >> 1-12-10 31-12-10 31 >> >> thanx >> >> >> -- >> Sudhir Verma >> Asstt. Mngr. A/c's >> 9818479722 >> * >> P think Before you print >> * >> * >> ** >> Life is Very beautiful !!! >> * >> * >> ¨`•.•´¨) Always >> `•.¸(¨`•.•´¨) Keep >> (¨`•.•´¨)¸.•´ Smiling! >> `•.¸.•´. >> * >> * >> * >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
