Returning the Week Number of a Specific Date on a Month
 

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

You can remove the time component with INT(A1)
as for which week, it depends on where you are
and even what it applies to. In the US it would
be WEEKNUM Worksheet Function which is described
on Chip's page, but for outside the US you might have
to use something else even though there are option on
the WEEKNUM Worksheet Function. Take a look at
Chip Pearson's page
Week Numbers In Excel
http://www.cpearson.com/excel/weeknum.htm

Use of your name and written English would be appreciated.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"arjcvg" wrote in message ...

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...