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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date filtering by number
On Fri, 9 Oct 2009 19:53:03 -0700 (PDT), Lynn
wrote: 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? Assuming that a week starts on a Monday, try this formula in cell D1: =1+INT((C1-TODAY()+WEEKDAY(TODAY(),3))/7) Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
date filtering by number
You can return the week number of a date we can use the WEEKNUM formula.
This will return a number that indicates where the week falls numerically within a year. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. €“ from your menu bar - ToolsAdd-ins. Formula syntax for the WEEKNUM formula:- WEEKNUM(serial_num,return_type) Serial_num is a valid date. Return_type is a number that determines the day the week begins. - Return_type 1 Default, (it can be omitted) the week begins on a Sunday. - Return_type 2, the week begins on a Monday. example: =WEEKNUM(C1) or =WEEKNUM(C1,2) hope helpful -- jb "Lynn" wrote: 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? |
Reply |
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 |