Issue in the date format in attached spreadsheet

Hello fnds,

In the attached excel sheet, how can I set the parameter so that date for a particular month will be displayed cumulatively.

If you have a look on the date for the month Decemeber in the spreadsheet which was retrieved from database, then available dates are 21/12/2012 11:58:35, 14/12/2012 10:28:29, 19/12/2012 8:54:46.



But when I select the month "Dec" through filter, only the date '7' is displayed (but not 21/12,14/12 and 19/12). Can I use any function so that all the dates will be populated under a particular month.

Advance Thanks..

A lot of your dates are actually text values which just look like dates and times. You can put this formula in B2:

=A2*1

and copy this down, to convert them all to Excel date/times, then your filter (on column B) will work properly.

Hope this helps.

Pete

In your worksheet, the date getting entered in dd-mmm-yyyy format for 7th December and for others in a long format of dd/mm/yyyy hh:mm:ss.

You need to make date in similar format in same column or in next column and then try filter. I hope this would do as per your requirement.

Tks.

---------------------------------------------------------------------------------------------------------
if my answer had helped you do not forget to click the * below and mark the thread as [solved]

Thanks all for your feedback but I m not getting final solution.
In the spreadsheet, other data columns are also present along with this date column while retrieved from database.
so the text function will not work becoz it filter only month, not date and year.

Is there any option available where date will be populated for partiular month as above.

Another approach is to enter 1 in a blank cell somewhere (let's say X1). Then select X1 and click <copy>, then move the cursor and highlight all the cells in column A which contain those dates, then right-click and choose Paste Special from the drop-down. Then in the dialogue box click against Values, and against Multiply, then click OK and then press the <Esc> key.

Then you should be able to apply the filter to the cells in column A - you can delete the 1 from cell X1 (or whichever cell you have used).

Hope this helps.

Pete