I got a question about excel and/or access table


  1. Posts : 16
    Win 7 beta
       #1

    I got a question about excel and/or access table


    Good day all experts,
    I got a question about excel and/or access table preferably 2003 version but if there is a lot of difference between the 2007I would like a solution to:
    I try to compare 1 date field and want to fill in a second date field that calculate the different the first date + 1 month and fill in another field with a Yes/No option in that row.
    So this is to calculate an invoice date + 1 month to receive the date overdue in another date field.
    I use the yes/no to do further calculations to merge and send out letters for those overdue.
    Table 1 Table 2 Table 3 Table 4 Table 5
    Invoice date: Date overdue: Amount overdue: Letter to send: Send date
    09/06/22 ? 100 Yes/No? ?
    I hope this all is clear!
      My Computer

  2.    #2

    =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))

    I'm sure you'll understand the logic

    Lee
      My Computer


  3. Posts : 16
    Win 7 beta
    Thread Starter
       #3

    Tanks theoriginalinvisible,

    It helped very much...just had to replace , by ; and it worked.
    Any idea how to flag field to be on/off or yes/no depending on that due date? versus invoice date?
      My Computer

  4.    #4

    I'm not sure what your conditions are for evaluating the yes/no option, but the formula would be something like:-

    =if(your_condition=true,"Yes","No")

    If you want to explain further then I'll gladly help. Send me a copy of the workbook if you like

    Lee
      My Computer


  5. Posts : 16
    Win 7 beta
    Thread Starter
       #5

    I try to compare 1 date field and want to fill in a second date field that calculate the different the first date + 1 month (THIS IS SOVED BY YOU) and then in a third field trigger an option field with a Yes/No or 1/0 or on/off option in that row depending if the field date overdue is true.
    Thanks for helping me out.

    Chris

    Attached test xls files

    Table 1 Table 2 Table 3 Table 4 Table 5
    Invoice date: Date overdue: Amount overdue: Letter to send: Send date
    09/06/22 ? 100 Yes/No? ?
    I got a question about excel and/or access table Attached Files
      My Computer

  6.    #6

    Is it overdue if date due (column G) is smaller than today?

    If so,

    IF(G2<=TODAY(),"yes","no")
      My Computer


  7. Posts : 16
    Win 7 beta
    Thread Starter
       #7

    Now i know i never been a programmer or im lazy or plain stupid...lol Thx lee
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 01:35.
Find Us