Hi, If you have Excel2007, you simply have to use the "this week" filter parameter. Else you have to use a elaborated filter. Look at the attached workbook. The criteria area is located in D1:E2. HTH Daniel
> -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of Lynn > Sent: samedi 10 octobre 2009 04:54 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ date filtering by number > > > I have a spreadsheet that lists, with start dates in column C. I would like to be > able to automatically number the dates which fall within the same week > > example, if start date falls within this week, column D will be labelled as 1. if > start date falls within next week, column D will be labelled as 2. if start date > falls within 3rd week, column D will be labelled as 3.... and so on... > > Can anyone clue me in as to how to do this? > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
date filtering by number.xls
Description: MS-Excel spreadsheet
