MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

need help in excel

  Asked By: Steven    Date: Oct 30    Category: MS Office    Views: 830

i already upload a file name : need help.xls

i have a data base in columns a and bolumn b has a date

i want to short data by month wise coloms ... with formula... please
any one help me....

please help... me as early as possible..



1 Answer Found

Answer #1    Answered By: Aberto Rossi     Answered On: Oct 30

I am assuming that you have the date column in mm/dd/yyyy format. In
column C enter formula  as '=month(b1). This will give you the month  and
then you can sort the data  by column 'C'. I hope this is what you are
looking for.

Didn't find what you were looking for? Find more on need help in excel Or get search suggestion and latest updates.