how about: fraction to the LASTMONT ( days in EndDate Month)
On Wed, Jul 13, 2011 at 9:28 AM, Dave Bonallack <davebonall...@hotmail.com>wrote: > Hi, > Fractions of a month are a bit subjective. Fractions of WHICH month, needs > to be decided. Fractions of a 28-day month? 29- 30- or 31- day month? Or > maybe a standardized 30.4375-day month? > Regards - Dave > > > On 12/07/2011, at 8:55 PM, Richard <richard.m...@gmail.com> wrote: > > 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
