Calculating the Length of Service between Hire and Termination dat Let's say somebody was hired on October 2, 2006 and left on August 14, 2009. I know that the YEAR function will return a value of 3.0. Is there a way I could calculate the Year and month i.e. in this case the length of service is 2 years and 10 months (ignoring the exact day of hire and termination) Or is th... 8 Mar 2010 11:57 Workbook with external links shows REF! error in 2007 not in 2003 I have a workbook that was created in Excel 2003. It has multiple links to external data sources that are not available to all users. When the workbook is opened in Excel 2003 and the user Selects "Do not Update", they can see the last values in the workbook. When this same workbook is opened in Excel 2007, the... 8 Mar 2010 10:50 Printing a color document - color is fading When I print a multi-colored Excel doc, the colors are faded. I don't think it's a problem with the printer. Have you experienced this before? ... 8 Mar 2010 16:26 index/if function A B C D E F G H I Acct# Inv# Date Amt Sales Total Alloc Alloc Alloc Tax Amt Amt S.Tax Total 68847 121508 1/15/09 \$2,358 \$2,358 \$0 \$0 \$0 68847 011509 2/1... 8 Mar 2010 10:50 Can offset be used in this formula? Can the offset be used in the below formula for the information in column "K"? In column L have the the following formula's L46 =MAX(\$I46*1000-\$K\$46*\$J46,0) L47 =MAX(\$I47*1000-\$K\$46*\$J47,0) .... L99 =MAX(\$I99*1000-\$K\$46*\$J99,0) What I'd like to do is to copy the fomula into columns M, N, O, ... M47 =MAX(\$I... 9 Mar 2010 16:58 Gathering Data using excel I have an output from an engineering program that exports data into excel. I would like to have a summary sheet where the pertinent data that I have can be seen instead of having my clients having to pour over hundreds of sheets. How do I get the text to appear. Example Cell A5 shows the text "A/V Alcove ... 8 Mar 2010 11:57 Can i get the Email Hello every one i want to know some clarification if its there? that is i have the some data that insurence expiry date shall i get the automatic mail for my mail ID once that date was expired? if that formula is there pls let me know. ... 8 Mar 2010 09:42 selecting records Hi I have a database with over 200 records containing several names with various times taken recorded against each record. I want to be able to sort, then select the best perfroming (fastest) and compile into a report (by name) preferably via Macro. I can do this manually but it will need doing on a month to... 9 Mar 2010 05:39 can you move icons on the quick access toolbar When you add a new command it is placed at the end of the list. I like to group similar commands together. How do you do this? ... 8 Mar 2010 05:20 conditional format Dear All I, create conditional format related to one column data range showing the staff ID, I want when I enter the staff ID if it is available in my data range, it will apply my conditional format, so my formula it is working for ID Like 1070, or 1470 But when I inter ID like B1101 It is not working, my form... 8 Mar 2010 04:15