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 -- ---------------------------------------------------------------------------------- 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
