How to extract info from excel spreadsheet that lies between a range of
date: e.g. col. header= S DATE, i want the range of dates between:
>1/1/04 & <12/31/04. I find no way to put this info in the pivot
table. Help?????????????
How to extract info from excel spreadsheet that lies between a range of
date: e.g. col. header= S DATE, i want the range of dates between:
>1/1/04 & <12/31/04. I find no way to put this info in the pivot
table. Help?????????????
Assuming they are real dates you can just group the date field on years and
drag that into the page fields, or just deselect the other years from the
dropdown, or even just create another field in your source data and use
=YEAR(DateCell) where DateCell refers to your dates.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks