+ Reply to Thread
Results 1 to 7 of 7

Need to find post dated cheque information as per date - please refer attachment

  1. #1
    Registered User
    Join Date
    04-29-2015
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    29

    Need to find post dated cheque information as per date - please refer attachment

    Hi guys,

    I NEED TO FIGURE A WAY TO IDENTIFY CHEQUES FROM A CODE NEXT TO THAT,

    ON NORMAL DAYS I ONLY NEED TO FIND WHICH CHEQUES ARE FOR THE NEXT DAY,

    BUT,

    ON WEDNESDAYS I NEED TO FIND CHEQUES FOR 4 DAYS AHEAD

    Please be kind enough to see attached workbook.

    Thanks.Book1.xlsx

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Need to find post dated cheque information as per date - please refer attachment

    Hi,

    I have updated the formula in the attached file in column "F", see if suits your requirement.
    Attached Files Attached Files
    Last edited by cbatrody; 04-30-2015 at 07:07 AM.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,580

    Re: Need to find post dated cheque information as per date - please refer attachment

    You can use this in F10 of your example sheet:

    =IF(D10="DEPOSIT",IF(WEEKDAY($C$8,2)=3,IF(AND(B10>=$C$8+1,B10<=$C$8+4),"DL","-"),IF(B10=$C$8+1,"DL","-")),"")

    then copy down.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    04-29-2015
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    29

    Re: Need to find post dated cheque information as per date - please refer attachment

    @cbatrody

    Good afternoon Greetings from Qatar,

    Thank you for your feed back.

    I checked the equation, but for some reason as of wednesdays it only goes upto finding 2 days in advance info. But I need 4 days in advance.

    anyways Brother Pete_UK has solved my puzzle and none other than me knows how relief I feel.

    Thank you very much again.

    Tc,

  5. #5
    Registered User
    Join Date
    04-29-2015
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    29

    Re: Need to find post dated cheque information as per date - please refer attachment

    @ Pete_UK

    Good afternoon Greetings from Qatar,

    Thank you x 1,000,000 TIMES BRO !

    This is great.

    You have saved my day and made my life easier at Work.

    I enjoy work in finance and the challenges which follows, and you made my day easy and now I have to look at how the equation works.

    Thanks a lot Bro.

    I feel Great.

    I posted the equation to the other line and adjusted the locked files to respective cells and it works like "I don't know what to say" - AWESOME

    Thank you again.

    Tc.

    Have a great day Pete.

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,580

    Re: Need to find post dated cheque information as per date - please refer attachment

    Thank you for your generous praise, and for marking the thread as SOLVED - glad to be able to help.

    As you are relatively new to the forum, you might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  7. #7
    Registered User
    Join Date
    04-29-2015
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    29

    Re: Need to find post dated cheque information as per date - please refer attachment

    @ pete_uk

    Bro,

    Mind teaching me how this coding is working actually?

    As I have very limited knowledge in if equations.(which seems really hard one to grasp)

    Thank you again..

+ 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. [SOLVED] (Urgent Req) VBA Code required to achieve this (Refer attachment)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2015, 11:32 AM
  2. [SOLVED] Cheque date have not reach yet and debt not deduct
    By choy96 in forum Excel General
    Replies: 1
    Last Post: 01-15-2015, 05:51 AM
  3. [SOLVED] Using macro to rearrange dated data from large spreadsheet using find loop (maybe?)
    By danb1985 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-03-2014, 01:44 AM
  4. Open multiple dated text files and import dated data specified in file name
    By andygxxxv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 03:56 PM
  5. [SOLVED] how do I refer to a cell using information from other cells
    By SCOTT in forum Excel General
    Replies: 5
    Last Post: 06-22-2006, 12:10 AM

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