| 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. |
| 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 | |||
Threaded Mode
