+ Reply to Thread
Results 1 to 10 of 10

To count the number of rows based on date and check how old the row is from current date.

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007/2010
    Posts
    17

    Question To count the number of rows based on date and check how old the row is from current date.

    hello all,

    This is my first post on the forum. I have been referring to this forum since a long time and i would like to thank you all for sharing and helping out the ones in need.

    I have a excel file (please find attachment). I need a macro or function to find how old the row is from current date and also find the count of rows that are older than 7 days, 15 days and 30 days. Please help me with this.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: To count the number of rows based on date and check how old the row is from current da

    Hi raovv,

    Try using below formula for rows older than 7 / 15 / 30 days :-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    see attached:- Copy of Z21A_21667_SPM_Sourced_Order_Report_20121011_065558 _IT.xls

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    01-03-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007/2010
    Posts
    17

    Re: To count the number of rows based on date and check how old the row is from current da

    Thanks a lot

    Quote Originally Posted by dilipandey View Post
    Hi raovv,

    Try using below formula for rows older than 7 / 15 / 30 days :-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    see attached:- Attachment 207557

    Regards,
    DILIPandey
    <click on below * if this helps>

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: To count the number of rows based on date and check how old the row is from current da

    you are welcome raovv

    Suggest you to mark this thread as [SOLVED]. thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    01-03-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007/2010
    Posts
    17

    Re: To count the number of rows based on date and check how old the row is from current da

    Hello DILIPandey,

    I have a situation now that using the same formula i need to count based on a criteria

    for example i tried this =SUMPRODUCT(--(N2:N11="Export"),($B$2:$B$20<=TODAY()-R2)*1)
    and it is giving me a #value error. Please help.

    regards

    rao.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: To count the number of rows based on date and check how old the row is from current da

    Hi Rao,

    There is no text like "Export" in N2:N11.. check again and upload the attachment if you have revised it since the time I saw that. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    01-03-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007/2010
    Posts
    17

    Re: To count the number of rows based on date and check how old the row is from current da

    Its a new requirement. There has been a change made to the existing document. Please find the new attachment. Your help is much appreciated

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: To count the number of rows based on date and check how old the row is from current da

    Its a new requirement. There has been a change made to the existing document.
    For new requirement, suggest you to post a new thread and mark this one as [SOLVED]. thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  9. #9
    Registered User
    Join Date
    01-03-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007/2010
    Posts
    17

    Re: To count the number of rows based on date and check how old the row is from current da

    okay. I will create a new thread.

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: To count the number of rows based on date and check how old the row is from current da

    thanks.. and also mark this thread as [SOLVED]..
    If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.
    Regards,
    DILIPandey
    <click on below * if this helps>

+ 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