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

1. ## 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. ## 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:
`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>

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

Thanks a lot

Originally Posted by dilipandey
Hi raovv,

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

Formula:
`Please Login or Register  to view this content.`

see attached:- Attachment 207557

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

4. ## 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. ## 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)

regards

rao.

6. ## 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. ## 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. ## 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. ## 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. ## 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]..
Regards,
DILIPandey
<click on below * if this helps>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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