For MTD you can convert the date (01/24/06 in cell A2) to Month by using

=TEXT(A2,"Mmm-YY") displays as "Jan-06"
=TEXT(A2,"MM/YY") displays as "01/06"

For week, I usually convert it to the week number in Oracle before
bringing it into Excel but you can use the add-in:

WEEKNUM
Returns a number that indicates where the week falls numerically within
a year. If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
If necessary, follow the instructions in the setup program.
Syntax

WEEKNUM(serial_num,return_type)

regards and good luck,

Jay


--
jbrackett
------------------------------------------------------------------------
jbrackett's Profile: http://www.excelforum.com/member.php...o&userid=32577
View this thread: http://www.excelforum.com/showthread...hreadid=526119