I am looking for a formula to look through a cloumn and let me know what customer jobs are due for that particular day. I recall using a "offset" function some time back but cant get it to work.
Eg.
Date ordered Due date Customer
1-Apr-10 4-Apr-10 Smith
2-Apr-10 5-Apr-10 Jones
2-Apr-10 5-Apr-10 Billy
3-Apr-10 6-Apr-10 Sean

What I need is a formula that will let me know that today (5april for instance) customer Jones and Billy are due.

Any help appreciated.
Alo please tell me how or if it is possible to cointnue a formula down a column without dragging it down?

All the best,