Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number
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(A30,FORMULA,""). Lastly, will I have to change date format in col A ??? Thanks in advance, Dunc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number
The date format does not need to be changed. In B1 =IF(ISBLANK(A1),"",weeknum(A1)) Drag down entire column. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=508110 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number
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 "Decreenisi" wrote: 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(A30,FORMULA,""). Lastly, will I have to change date format in col A ??? Thanks in advance, Dunc. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Number
Thanks Steve, that was just perfect.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
evaluate data by week number | Excel Worksheet Functions | |||
Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
number of week | Excel Worksheet Functions | |||
how to get week number in month in excel ? | Charts and Charting in Excel |