Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if function
I have a column A with 1000 different dates. I want excel to look up the dates and if it falls under a specific date range, label column "B"s respective cells a certain Fiscal week. For example: 1/31/2005 Q1,WK1 2/1/2005 Q1,Wk1 2/2/2005 Q1,Wk1 2/3/2005 Q1,Wk1 2/4/2005 Q1,Wk1 2/7/2005 Q1,Wk2 2/8/2005 Q1,Wk2 2/9/2005 Q1,Wk2 2/10/2005 Q1,Wk2 2/11/2005 Q1,Wk2 -- mazalam ------------------------------------------------------------------------ mazalam's Profile: http://www.excelforum.com/member.php...o&userid=26768 View this thread: http://www.excelforum.com/showthread...hreadid=468810 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |