I forgot to say that YEARFRAC is from the Analysis ToolPak Dave.
From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help on excel formula Date: Wed, 3 Feb 2010 13:01:33 +0800 Hi I've used the YEARFRAC funtion and multiplied it by 12. Have a look at the attached. Some of your manual entries were incorrect. I have highlighted them in yellow. Regards - Dave. Date: Wed, 3 Feb 2010 00:18:50 +0530 Subject: $$Excel-Macros$$ Help on excel formula From: karankan...@gmail.com To: excel-macros@googlegroups.com CC: karankan...@gmail.com Hi, I have an excel sheet where i have to calculate the difference between 2 dates giving the answer in months. e.g. Difference between these 2 dates 31-3-09 & 1-2-07, and the answer to be in months. I have calculated the difference between the dates (by using a formula), but in few cases there is a difference of one month which i am getting, which is wrong. Pls find the attached sheet and give me a formula which can be used for the entire sheet and that i dont get any difference between the calculated and the actual correct months. The "Difference" is marked in red. Thanking you in anticipation. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 Sell your old one fast! Time for a new car? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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 _________________________________________________________________ View photos of singles in your area! Browse profiles for FREE http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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
