Try it like this:

DATE(YEAR(U4),MONTH(U4),1)

I like this better:

U4-DAY(U4)+1

Biff

"edwardpestian"
wrote in message
news:edwardpestian.2c97pk_1155095411.8235@excelfor um-nospam.com...

So I cannot use the year in U4 too? I tried this, but am getting a #NUM!
error.

=IF(U4-6<DATE(U4,U4,1),HLOOKUP(U4-6,Data!B23:AF27,4,FALSE)/1000,HLOOKUP(U4-6,Data!B5:AF9,4,FALSE)/1000)

Regards,

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=569742