HI

I CANNOT GET MY HEAD AROUND THIS ONE SO AFTER A WEEK OF TRYING HERE IS MY
PROBLEM
IN COLUMN AB, ON WORK BOOK "OFFICE MNAGERS CALANDER.XLS, WORK SHEET 'DATES'
i HAVE THE DAILY DATES FOR EACH DAY FOR 2010 OVER 365 ROWS USING
=DATE(2010,1,1)+ROW()-1

IN ANOTHER WORK BOOK, THE ROAD ACCOUNTING PROGRAM.XLS, WORK SHEET 'DATE
DETAILS' , STARTING IN COLUMN C ROW 3 THE DATE OF THE FIRST DATE OF THE TOUR,
THEN D3 THEN E3 , THEN F3

I HAVE MANAGED ON THE, OFFICE MANAGERS CALANDER.XLS USINIG INDIRECT FUNCTION
AND iF FUNCTION TO BE ABLE TO PICK OUT THESE DATES AGAINST THE 365 DAYS WHICH
LEAVES ME WITH IN COLUMN AD
O
O
O ETC(AGAINST DATES NOT ON TOUR)
AND
1
1
1 ETC AGAINST DATES THAT ARE ON TOUR

MY AIM IS TO GET ACTUAL CITIES AGAINST THE FIXED DATE LIST INSTEAD OF THE 0
OR 1

ACTUAL CITIES ARE THE ROAD ACCOUNTING PROGRAM.XLS, WORK SHEET 'DATE DETAILS'
, STARTING IN COLUMN C ROW 5 THE DATE OF THE FIRST DATE OF A TOUR, THEN D5
THEN E5 , THEN F5 ETC

HOPE i HAVE DESCRIBED THIS WELL ENOUGH TO ALLOW SOMEBODY TO COME UP WITH A
FORMULA

THANKS FOR LOOKING

Stew