Hi All, I would appreciate a vba function that will calculation the number of months and fraction of a month between 2 dates. i.e. January 1, 2011 to February 14, 2011 would be 1.5 months January 1, 2011 to February 15, 2011 would be 1.5335714 January 1, 2011 to March 15, 2011 would be 2.483871 Thank you in advance Rich
-- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel