| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Something other than DATEVALUE
I have the following formula that uses datevalue to determing what range to lookup. I'd rather not use datevalue as each month I will have to change the value to the first of that month. Is there something I can use that will automatically find the first day of the month based on the month in U4 - which is a drop down menu (Data Validation list containing the dates of the month). =IF(U4-6<DATEVALUE("08/01/2006"),HLOOKUP(U4-6,Data!B23:AF27,4,FALSE)/1000,HLOOKUP(U4-6,Data!B5:AF9,4,FALSE)/1000)) Thanks. -ep -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=569742 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date-related problems - max and datevalue | Excel Discussion (Misc queries) | |||
| DateValue Problem... | Excel Worksheet Functions | |||
| DATEVALUE works on one sheet, not another | Excel Worksheet Functions | |||
| DATEVALUE QUESTION | Excel Worksheet Functions | |||
| Bug in DATEVALUE command in Excel 2002?? | Excel Worksheet Functions | |||
Threaded Mode
