+ Reply to Thread
Results 1 to 1 of 1

CPI Date

  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2003
    Posts
    53

    CPI Date

    I am looking for a formula which would return a CPI review date on a lease data base.
    Each lease is reviewed every 3rd year for increase according to the CPI Index. We abated this review due to the economic conditions for years 2009,2010&2011. If your lease had a cpi date in those years, I need to capture that fact and identify the year.
    I think a simple math formula would work but I've racked my brain to no avail. The worksheet attached shows the array. Any help appreciated.
    Mike
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1