Thread: Something other than DATEVALUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian edwardpestian is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote