Hi Stew,
I am having problems following your request. If you could maybe put some
sample data in your request, it might be easier to follow. For instance, it
sounds like you have two workbooks and both contain dates. I would probably
put a small sample like this:

Office Mgr Calendar:
Column AB Column AC
01/01/10 ?
01/02/10 ?

Road Acct:
Col C Col D Col E
01/01 01/02 01/03
city city city

If my guess at setup is correct, it sounds like you need an Hlookup formula
that would pull in the name of the city. Maybe that is what you were using?
I'm not certain if you would even need the indirect & if functions but
without knowing the whole picture, I can't say.
--
Constance


"stew" wrote:

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