| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find first row number after filtering | Excel Programming | |||
| Filtering by a date | Excel Discussion (Misc queries) | |||
| Filtering and Text/number problems | Excel Discussion (Misc queries) | |||
| Not filtering by date | Excel Programming | |||
| Not filtering by date | Excel Programming | |||
![Lynn[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
