Yes, DATEDIF is a worksheet function available in Excel please visit to: http://www.cpearson.com/excel/datedif.aspx
"The DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates. This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation." On Fri, Sep 3, 2010 at 6:00 PM, shrinivas shevde <shrinivas...@hotmail.com> wrote: > Dear siti vi/Group Member > > Plesae let me know What is the function DATEDIF ? > Is this function available in Excel? > If not How u insert function in Excel. > Thanks in advance > > shrinivas > > ________________________________ > Date: Fri, 3 Sep 2010 09:29:35 +0700 > Subject: Re: $$Excel-Macros$$ sumif kinda formula needed > From: villager.g...@gmail.com > To: excel-macros@googlegroups.com > > Formula for AGE and UDF for SUMMARY > see attachments -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe