I have a series of dates. How can i filter dates that are within this week? thanks
L Lynn Oct 10, 2009 #1 I have a series of dates. How can i filter dates that are within this week? thanks
D Dave Peterson Oct 10, 2009 #2 I would add another column to represent the year and week number. Then filter on that. Excel has its own =weeknum() function (requires installation of the analysis toolpak in xl2003 and below). But week numbers mean different things to different people/groups/organizations. I'd start with Ron de Bruin's site if excel's =weeknum() isn't sufficient: http://www.rondebruin.nl/weeknumber.htm http://www.rondebruin.nl/isodate.htm
I would add another column to represent the year and week number. Then filter on that. Excel has its own =weeknum() function (requires installation of the analysis toolpak in xl2003 and below). But week numbers mean different things to different people/groups/organizations. I'd start with Ron de Bruin's site if excel's =weeknum() isn't sufficient: http://www.rondebruin.nl/weeknumber.htm http://www.rondebruin.nl/isodate.htm
R Ron de Bruin Oct 10, 2009 #3 Fo the OP Easyfilter have a option to filter on weeks also http://www.rondebruin.nl/easyfilter.htm For Excel 2007 i have a ISO weeks option in this add-in http://www.rondebruin.nl/table.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm
Fo the OP Easyfilter have a option to filter on weeks also http://www.rondebruin.nl/easyfilter.htm For Excel 2007 i have a ISO weeks option in this add-in http://www.rondebruin.nl/table.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm
