background preloader

Misc.

Facebook Twitter

Random Item / Person selector / Generator fruit machine. Mandisa - Overcomer. Random Item / Person selector / Generator fruit machine. Eric Thomas. DATEDIF Worksheet Function. The DATEDIF Worksheet Function This page describes the undocumented DATEDIF worksheet function. 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. Do not confuse the DATEDIF worksheet function with the DateDiff VBA function. The syntax for DATEDIF is as follows: =DATEDIF(Date1, Date2, Interval) Where:Date1 is the first date,Date2 is the second date,Interval is the interval type to return. If Date1 is later than Date2, DATEDIF will return a #NUM! =DATEDIF(Date1,Date2,"m") =DATEDIF(Date1,Date2,A1) For the Home. Free Microsoft Access Training. My Learning Plan ® - Home. Prestonjjrtr's Winter album. Prestonjjrtr's media. The beauty of pollination - YouTube. Good Morning- Mandisa Feat. TobyMac (with lyrics) Calculate a Person's Age in Excel Based on Their Birthday.

Individual merge letters. Many people access the material from this web site daily. Most just take what they want and run. That's OK, provided they are not selling on the material as their own; however if your productivity gains from the material you have used, a donation from the money you have saved would help to ensure the continued availability of this resource.

Click the appropriate button above to access PayPal. This popular add-in has undergone many revisions. Please keep an eye on the What's New page for new releases. To avoid preparing a complete set of new illustrations to cover minor changes in presentation, some of the illustrations shown will be from earlier versions. The add-in is provided in two versions: a dot format template intended to work with Word from version 2002 and 2003, and a dotm format template for Word versions 2007 and Word 2010 (32 and 64 bit versions). There are download links before the macros listings and at the end of the page, but please read the instructions first. Adobe Acrobat. Journey. Online Calendar: Ohio Virtual Academy Events [Month view: 6/12] K¹² - Online Support Center.