I am able to split my data in Month and Year on using...
Month (Date) as Month,
Year (Date) as Year,
[C:\Documents and Settings\Fact3724250950917500274.xls]
(biff, embedded labels, table is Fact$);
But plz tell me the command by which i can devide the Date or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .