On Jun 18, 2:02*pm, Johnnyboy5 wrote:
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
Hang on...I think I have got it now...using "Week Number From Date"
with a few $ signs added
thanks - job done
John