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