| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the date using the number of the week in a year
Hi All,
I have manipulated some data and managed to get the week number of each row and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in any particular year. e.g. for today (27 Mar 2007): week number = 13 year = 2007 day = 2 (2 for tuesday). Using this data, is there anyway i can return the actual date for today (e.g. 27-Mar-07) using a formula ? Any help would be much appreciated. Regards, Bhupinder. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the date using the number of the week in a year
One way:
A1: 2007 A2: 13 A3: 2 B1: =DATE(A1,1,A2*7-WEEKDAY(DATE(A1,1,0))+A3-6) In article , Bhupinder Rayat wrote: Hi All, I have manipulated some data and managed to get the week number of each row and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in any particular year. e.g. for today (27 Mar 2007): week number = 13 year = 2007 day = 2 (2 for tuesday). Using this data, is there anyway i can return the actual date for today (e.g. 27-Mar-07) using a formula ? Any help would be much appreciated. Regards, Bhupinder. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the date using the number of the week in a year
great, nice one JE, cheers.
"JE McGimpsey" wrote: One way: A1: 2007 A2: 13 A3: 2 B1: =DATE(A1,1,A2*7-WEEKDAY(DATE(A1,1,0))+A3-6) In article , Bhupinder Rayat wrote: Hi All, I have manipulated some data and managed to get the week number of each row and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in any particular year. e.g. for today (27 Mar 2007): week number = 13 year = 2007 day = 2 (2 for tuesday). Using this data, is there anyway i can return the actual date for today (e.g. 27-Mar-07) using a formula ? Any help would be much appreciated. Regards, Bhupinder. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Friday in week number | New Users to Excel | |||
| how to insert month date year and day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | New Users to Excel | |||
| how to insert month date year and day of week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Hybrid Mode
