3 Resources for

datedif

Sponsored White Papers, Webcasts, and Downloads

Help on an Excel formula: I need some help on an Excel formula..I need to calculate a formula to count the exact number of days between two dates.For Example:Cell A1 contains 01/01/2007Cell A2 contains 31/01/2007Cell A3 needs to contain the answer (31)All the formula's i can think of return the answer (30).I would very much...; Tags: Microsoft Excel, benpatel@..., DATEDIF, A2,B2, DATEDIF function; Discussion threads 2007-10-14
Tech Tip: Save to the right Word folder/Calculate a person's age in Excel/Delete fields from an Access query: Make sure users save to the right folder By default, Word automatically saves all filesto the My Documents folder. But if you prefer users to save allfiles to another folder, such as one located on the company server,they don't need to navigate to that folder each time...; Tags: B2,NOW, DATEDIF, irrelevant criteria, Microsoft Access, Microsoft Word; Technical articles 2004-08-03
Teach Excel users to calculate elapsed time: A TechRepublic member we'll call Zee wrote asking for help with date math. Zee, who works for a small correctional institute, had an Excel spreadsheet with the following information:Date of entryDate of scheduled departureUsing that data, Zee wanted to calculate two new columns, "length of stay in years, months, and...; Tags: DATEDIF, Jeff Davis, Zee; Technical articles 2003-01-29

Excel Formula Continuous Services Date: I'm trying to help our HR Department develop a spreadsheet to calculate continuous service dates for employees with a break in continous service, using Excel 2000. Hire Date Term. Date Original Hire: 9/10/1973 through 12/8/1978=5 years, 2 months, 28 daysRehired: 9/22/1980 throuhg 12/31/2005=25 years, 3 months, 9 daysHere is the...; Tags: E152,F152, Microsoft Excel, pvbridges, software; Q&A 2005-06-21
calculate days between months: Hi,I need to know how to calculate the number of days between 01/02/2005 and 31/05/2005 using excel.DATEDIF(start_date,end_date,unit)start_date and end_date can be relative cells as well.Do not know how accurate it is but i find the DAYS360 a handy function.e.g =Days360(A2,B2,false)Where the cell A2,B" are cell referenceshttp://tinyurl.com/8tulbLearn how here.Lee; Tags: cell; Q&A 2005-06-01

Knowing and meeting user expectations is key to designing great functions: By Beth BowdenA great function usually does only one thing but does it supremely well. Once you learn to use a great function, you can use it immediately and frequently without ever thinking about how to use it or how it works—much like breathing. A poor function, on the other...; Tags: Guest Contributor, differenceInDays, dtDF; Technical articles 2003-04-03
Excel Formula: Excel Formula not working... I hope this is where I post this question? I have a MASSIVE formula that I using to accrue vacation time based on different criteria. Basically I am wanting to use the same formula that I'm using now, just add something to it. I can not...; Tags: A3, jprogrammer, Microsoft Excel, software, YEAR; Q&A 2005-09-08

Quick Reference: PC Troubleshooting Pack: Help desk and IT support professionals need the fastest and most complete answers to keep every PC in action. Get the PC troubleshooting solutions you ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now