On Jun 18, 11:19*am, "Jim Cone" wrote:
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 ...







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

Yes your right - however if I use the first formula today's date
18/6/11 says its week 25 when its still week 24 20/6/11 (Monday)
would be the start of week 25

Wow !

I like the first one


"Week Number Absolute"

but how could it be written to have Monday being the first day of the
week ?

The others are a bit complex for me !

thanks

John