Hi im new to this board, but im finding im suing excel more and more for my job, and need some help with a few things

First things first, i work for a supplier, and we have a number of wholesale customers, one of which we phone all there restaurants (98 a week) and i have a spreadsheet set out to record there orders. This simply involves me putting a 1 in the cell corresponding to the day they placed there order.

Want i want to do is create a formula which will return a 1 in a cell next to the next to the restaurant in column B if it has put in an order during the current week. So along the top of the sheet is a merged cell containing the start of each week, then five cells underneath each containing date of each day. Below all that before the fields containing the ordering date (1 or a 0) is a row of merged cells which contain either a 0 or a 1 for the current week. I also have cells at the start of the document that return the current date, and the commencing date of the current week.

A lot of this i have simply added to try and solve the problem but ive been trying with out success for a few days now.

So basically what i want to do is return a 1 in column B next to each restaurant if during the current week the restaurant has put in an order.

Failing that, a way to return the value of the five cells for the restaurants five days on that week would be ace.

CHEERS in advance

Ali the cheesemonger