TODAY()

[ExcelRoy]

Hi all,

I am looking to use a formula to list orders placed at certain times

I am trying the following

=IF(B9="","","Orders Placed 1 to 7 Days > "&COUNT(E23:E122,TODAY()-7))

But when I use this style of formula whatever the - I use after TODAY it shows exactly the same result of 26?

Not sure where I am going wrong

All of E23:E122 has formula in them but ot all will show a date

Many thanks for any help

 

[Michael M]

Try changing the count to countif

&COUNTIF(E23:E122,TODAY()-7))

 

[Peter_SSs]

My interpretation of your requirement is

=IF(B9="","","Orders Placed 1 to 7 Days > "&COUNTIF(E23:E122,">="&TODAY()-7))

 

[ExcelRoy]

Hi Peter,

That's great many thanks

Could this be changed to a range, ie 1-7 days, 8-14 days, over 14 days

Thanks again

 

[Peter_SSs]

Could this be changed to a range, ie 1-7 days, 8-14 days, over 14 days

You may need to tweak the numbers and the >= versus > symbols to get the exact count you need but these should get you headed in the right direction.

=IF(B9="","","Orders Placed 8 to 14 Days > "&COUNTIFS(E23:E122,">="&TODAY()-14,E23:E122,"<"&TODAY()-7))

=IF(B9="","","Orders Placed over 14 Days > "&COUNTIF(E23:E122,"<"&TODAY()-14))