+ Reply to Thread
Results 1 to 2 of 2

Formula to flag missed periods

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Formula to flag missed periods

    Hello,
    I am working on an idea I have to automate expense accruals. I have a data grid that shows all of the vendor history. One of the columns is periods/months. I want to test on this column to flag when an accrual is needed. example. I have a landscaping vendor. The history shows in the period column that we have paid them months 1 through 8. If we are in period 10 I want the flag that an accrual is needed. So the tool would know we are in period 10 and it would see that we have made 8 consecutive payments and are missing 2. Same concept where the history shows we pay someone quarterly. search the periods and see that we have paid a vendor for 2 quarters and need to accrue for the third quarter.

  2. #2
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Re: Formula to flag missed periods

    here is an example of the file. the period field is column M
    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)

Similar Threads

  1. Get the number of missed payments and missed payments of interest
    By chergian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2016, 08:37 PM
  2. [SOLVED] Formula to highlight missed completion dates
    By AndyRic in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-11-2014, 12:28 PM
  3. [SOLVED] I want to flag any user that has missed more then 2 weeks in attendance
    By slasherdan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-03-2013, 07:40 PM
  4. flag up message if a date is missed
    By baz0912 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2008, 10:35 AM
  5. Need a formula to flag a cell
    By Greeneyez2 in forum Excel General
    Replies: 4
    Last Post: 06-20-2006, 06:15 PM
  6. IF formula to flag exp dates
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. IF formula to flag exp dates
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

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