1 Reply Latest reply: Apr 24, 2015 12:15 PM by Olly Bond RSS

    Count the Number of Months since a date

    Chuck Kennedy

      Hey All,


      I am new to this discussion group, but I have been using Monarch for several years and love it.  I just switched jobs and they purchased V12 for me and I am brain dead on how to do this.

       

      I am creating a report on Fixed Assets that will create a summary report that shows in  Month 1, $xxxx of assets will be fully depreciated.  I have no problem with anything but counting how many months have passed since the asset was put into service and subtracting that from the total months the asset will be depreciated.

       

      Example.

       

      Asset A Inservice 1/1/10.  Todays Date is 4/24/15 so how many months has passed...

       

      What formula would you use to do that?

       

      Thanks

      Chuck