+ Reply to Thread
Results 1 to 5 of 5

Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

    Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

    Ok. So what I am trying to do is add the text "Late" to column J and add the number "5" to column K, but only if date entered in column G is past the 20th of whatever month. My customers are subject to a $5 late fee if monthly payment isn't received by the 20th. My business is growing and it is becoming difficult to do this on a one-by-one basis. I have tried to play around with the SUMIF formulas but I really think that this one is over my head. Any help with this matter is greatly appreciated!!

    Thanks again for your time!
    LaurenL


    Accounts Receivables.xlsx

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

    Hi Lauren,

    In column J you can use:

    =IF(DAY(G4)>20,"Late","")

    In column K you can use:

    =IF(DAY(G4)>20,(F4-H4)+5,F4-H4)

    Hope that helps!

  3. #3
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

    Paul, Thank you very much. Thi did exactly what I was hoping it would. Is there anyway to apply this formula to the entire column rahter than entering it in row by row?

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

    You can use the "Fill Handle" to fill a formula down many rows. Hover over the lower right corner of a cell with the formula until the cursor becomes a + sign. At that point, click down on your left mouse button and drag your mouse downward. Once you've selected as many rows as you need, let go of the mouse button. You can fill any direction using this method, just beware how your formula will change as you do so (i.e. using absolute vs. relative cell references).

    Glad I could help!

  5. #5
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Add late fee. Inserting text and numbers in sep clumns IF date entered is past 20th

    Thanks. I didnt even think about that.

+ 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