Help for Countif with 30 day Date Range situation.

  • Hello all,


    Please help me with the below request. In the below table there are some date and Serial numbers. What i want is that count of serial numbers which re-appeared within 30 days from Date. Ex: The Serial number which appeared on 8/6/2013 L3AAB8Y - 350M same as reappeared within 30 days on 9/1/2013 and that should be counted. However another serial number which is appeared on 8/1/2013 L3AGD7K - 35ZG is again reappeaed after 30 days should not be counted.


    I hope i have explained my situation clearely here. Advance thanks ...NG
    [TABLE="class: grid, width: 500"]

    [tr]


    [td]

    Date

    [/td]


    [td]

    Combine Serial

    [/td]


    [/tr]


    [tr]


    [td]

    8/6/2013

    [/td]


    [td]

    L3AAB8Y - 350M

    [/td]


    [/tr]


    [tr]


    [td]

    8/7/2013

    [/td]


    [td]

    L3AGD7K - 23JC

    [/td]


    [/tr]


    [tr]


    [td]

    8/1/2013

    [/td]


    [td]

    L3AGD7K - 35ZG

    [/td]


    [/tr]


    [tr]


    [td]

    8/8/2013

    [/td]


    [td]

    [TABLE="width: 185"]



    [tr]


    [TD="align: right"]

    [/tr][/td][tr]


    [td]

    L3AGF8Y - 3FLP

    [/td]


    [/tr]



    [/TABLE]
    [/TD]

    [/tr]


    [tr]


    [td]

    9/1/2013

    [/td]


    [td]

    L3AAB8Y - 350M

    [/td]


    [/tr]


    [tr]


    [td]

    9/1/2013

    [/td]


    [td]

    L3AGD7K - 23JC

    [/td]


    [/tr]


    [tr]


    [td]

    9/10/2013

    [/td]


    [td]

    L3AGD7K - 35ZG

    [/td]


    [/tr]


    [/TABLE]

  • Re: Help for Countif with 30 day Date Range situation.


    Cross posting here..


    http://www.excelforum.com/exce…date-range-situation.html

    Regards


    Fotis :hammerhe:


    [SIZE=4]. [/SIZE]Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.


    [SIZE=4]. [/SIZE]-Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.


    [SIZE=4].[/SIZE]--Don't attach a screenshot--Just attach your Excel file!


    [SIZE=4].[/SIZE]--[SIZE=3]KISS[/SIZE]([SIZE=2]Keep it simple Stupid[/SIZE])

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!