You could also take the number of day elapsed on the warranty divided by the number of days of warranty and multiply by number the months for the warranty.
Gary ________________________________ From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, August 26, 2010 12:15:14 PM Subject: [RBASE-L] - Re: month calculations Dan, A rudimentary calculation would be to divide the days left by 30.5. It would give you a rough idea of the months left in a warranty. Jan -----Original Message----- >From: "Dan Goldberg" <[email protected]> >To: [email protected] (RBASE-L Mailing List) >Date: Thu, 26 Aug 2010 10:02:27 -0700 >Subject: [RBASE-L] - month calculations > > >I am perplexed on a calculation I need to do. > >I need to find out how many months is left in a warranty. So it would be today >minus the sold date. > >I can get the amount of days left in the warranty by just subtracting them but >they want the amount of months left. > >I am looking at the functions but am hitting a brain lock on how to calculate >the months left. > >Help!! > >Dan Goldberg
