Results 1 to 9 of 9

Aging report formula not working for 0-30 days past due

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2015
    Location
    Layton, Utah
    MS-Off Ver
    7
    Posts
    4

    Aging report formula not working for 0-30 days past due

    I am so new to using excel that I hope if what I am asking make sense since I don't know all of the lingo. I have created an insurance claim aging report. The columns for 31-60 days, 61-90 days and over 90 days columns are working fine and calculating how they should be. However, for some reason, I can't figure out the 0-30 day column. I will post the formula that I used for the 31-60 day column.

    =IF(AND($F6>=31,$F6<=60),$E6,"")

    Can anyone tell me how to do the 0-30 day column?

    Let me know if this is not enough info in order to help me.

    Thanks in advance for any advice given.
    Last edited by Lorir1; 08-04-2015 at 12:22 PM. Reason: Informed of wrong title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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