I have a small sheet of allocated work / cases to be seen, in column
C cells would like the WEEK number to be automatically entered when
the allocation date is entered into column D cells. Or the other way
round e.g. I dont mind making column C the date then column D the
week number.

EG


WEEK Allocated
A B C D
X X 24 17/6/11


thanks

John