I assume your question is not really how to write an "If" function but how to determine the week
number...
http://www.cpearson.com/Excel/WeekNumbers.aspx
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Extras for Excel add-in: convenience built-in)




"Johnnyboy5"
wrote in message
...
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