Find Items that are XX many days old

**jrieder21** · 03-27-2014, 02:35 PM

Hello

I have a Huge Spreadsheet that i need to find out of the list how many days old tickets are and break them down. Below are just random dates but i want to be able to find how many out of the list below are 25/30/45/60 and what ever other day i please. Is it possible to tell excel to give me items that are ONLY 25 days or 24 DAYS OLD.

I know there are formulas that you can put in like =Now()- but this will give me everything up to 30 days. I want a formula that will five me items that are ONLY 25 days not greater or less

DATE SUB
2/25/2014
2/26/2014
2/27/2014
2/27/2014
2/27/2014
2/28/2014
2/28/2014
2/28/2014
2/28/2014
3/3/2014
3/3/2014
3/3/2014
3/4/2014
3/4/2014

**hemesh** · 03-28-2014, 12:52 AM

assuming your dates are in Column A
then in C1 copy paste below hold control and shift together and then hit enter
=SUM(IFERROR((TODAY()-A1:A100=25)*1,0))

**jrieder21** · 03-28-2014, 08:45 AM

I am sorry im not following can you please explain in more detail

**foundy** · 03-28-2014, 09:00 AM

Hi jrieder21,

If I'm right in saying, you want to be able to just view the records in the sheet where the date is, say 25 days old. Have you tried the filter that Excel offers?

Select Table of data > Home > Sort & Filter > Filter

Select the date column and enter the date you are looking for. This will show you all the records with that date.