+ Reply to Thread
Results 1 to 2 of 2

Cheque date have not reach yet and debt not deduct

  1. #1
    Forum Contributor
    Join Date
    03-19-2010
    Location
    singapore
    MS-Off Ver
    Excel 2019
    Posts
    170

    Cheque date have not reach yet and debt not deduct

    i going to to do a table to record debt by paying by advance cheque. when the date cheque have not reach yet, debt will not deduct the amount from the cheque. when date is today or after today, it will deduct the debt.

    please refer to the attachment.

    thanks in advance.
    Attached Files Attached Files
    Last edited by choy96; 01-16-2015 at 03:59 AM.

  2. #2
    Forum Contributor
    Join Date
    10-04-2014
    Location
    Europe
    MS-Off Ver
    2007
    Posts
    107

    Re: Cheque date have not reach yet and debt not deduct

    Hi
    Is this what you need? It is in M4:M9.

    Regards.
    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. how to deduct number to a date
    By Enigma Trio in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-14-2014, 04:07 AM
  2. The formula to calculate the date of repayment of debt
    By SDCh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2013, 05:49 AM
  3. Replies: 5
    Last Post: 02-11-2013, 12:00 AM
  4. Deduct one date from another
    By ExcelBob in forum Excel General
    Replies: 3
    Last Post: 05-16-2008, 10:32 AM
  5. [SOLVED] Need to know percapita consumer debt. Debt amount is 2121.1 bill.
    By cabe88 in forum Excel General
    Replies: 6
    Last Post: 03-09-2005, 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