You need to clarify what you mean by select. A formula cannot be used to
work out all instances of a day and then select them in the classic sense,
but it can say add all items for a particular day.

More detail, and example data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Terry" wrote in message
...
hi trying to select days of week in spreadsheet amount of each day varies
each week and would like to use formula instead of manually etering cell
references each day.