software

Hi, Can anyone help me out please ? I have an excel spreadsheet to
track reject activity at the customer. In col A is the date (Format
03-Feb-06). In col B I want to autofill the week number, from the date
in col A. I also want Col B to be blank if there is no date in col A. I
think I can do that with =IF(A3gt;0,FORMULA,quot;quot;). Lastly, will I have to
change date format in col A ???
Thanks in advance, Dunc.
The date format does not need to be changed.

In B1

=IF(ISBLANK(A1),quot;quot;,weeknum(A1))

Drag down entire column.

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=508110
Try this
CEILING(DAYS360(DATE(YEAR(A4),1,1),A4)/7,1)

replace Formula in your Formula with the above -- the If statement you have
is correct and no you will not need to change date formats...

wAyne

quot;Decreenisiquot; wrote:

gt; Hi, Can anyone help me out please ? I have an excel spreadsheet to
gt; track reject activity at the customer. In col A is the date (Format
gt; 03-Feb-06). In col B I want to autofill the week number, from the date
gt; in col A. I also want Col B to be blank if there is no date in col A. I
gt; think I can do that with =IF(A3gt;0,FORMULA,quot;quot;). Lastly, will I have to
gt; change date format in col A ???
gt; Thanks in advance, Dunc.
gt;
gt;

Thanks Steve, that was just perfect.