| 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. |
| 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) | |||
Threaded Mode
