+ Reply to Thread
Results 1 to 8 of 8

Display Due Date

  1. #1
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Display Due Date

    Hi,
    I have a some data in Sheet1, in which G column & J column have mentioned dates. I need to show the G columns date which is <= 90 days from today & J column date will show which is <=60 days. This due date will show each time when i will open it. It just like a reminder. Thanks.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Display Due Date

    See if this gets you started?

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Re: Display Due Date

    Thanks Mr. John for your reply. But what i need is little bit difference. The mentioned code is only showing only the G rows and J rows are overdue like this. But i need it will mention the cell name of B column means in B column i have mentioned names of Customers. if a particular customer's date is due in 90 days then it will show like "Customer XX's Due Date is (Date of G / J value) & Need to Renewal. If in a column there are 4/5 records for Renewal it will show the total Dates like in Listview. I think you got my problem what i want. Thanks.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Display Due Date

    Can you attach a sample with your layout?

  5. #5
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Re: Display Due Date

    Hi,
    Herewith i have attached the file for your reference. The result i need is " The Customer Sanket's Due Date for Renewal Agreement is 17-12-2014" & the 2nd column for J is "The Customer Pitamber's Due Date for Renewal S & E Agreement is 31-10-2014". I have almost 200 above records are there. i need the result will show every time when i will open the file. So what i can follow up easily. If there is 15 records is for due then it will show one after one record.Example Sheet.xlsx

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Display Due Date

    Check your math in order to get those results. Try this:

    Please Login or Register  to view this content.
    If you come up with the desired math to get your results, then we can get it set up in Workbooks Open event code.

  7. #7
    Forum Contributor
    Join Date
    02-16-2011
    Location
    Maharashtra, Thane
    MS-Off Ver
    Excel 2021
    Posts
    140

    Re: Display Due Date

    Thank you very much Mr. John. I got the result what exactly i needed. Again Thanks.

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Display Due Date

    You're welcome. Glad to help out and thanks for the feedback.

+ 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. Replies: 2
    Last Post: 04-23-2014, 09:07 AM
  2. Replies: 8
    Last Post: 03-07-2014, 03:12 PM
  3. [SOLVED] Display Fridays date (and message) if current date is Monday
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2013, 09:40 AM
  4. Replies: 1
    Last Post: 03-16-2011, 11:05 PM
  5. Replies: 3
    Last Post: 02-26-2009, 04:28 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