hi! It's me again

I just wanna ask, for example i have this data

10/21/2004 3:02:08 PM

How will I remove the the time value?

And for the same date,

How will I return the week number of that date on that month.

On the example date, 10/21/2004 is on week 2 of October...


Thanks a lot for your help!


--
arjcvg
------------------------------------------------------------------------
arjcvg's Profile: http://www.excelforum.com/member.php...o&userid=12713
View this thread: http://www.excelforum.com/showthread...hreadid=274756