| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
week No to date
Hi
I have some data with the date reprisented by a week No I want to make a date on the Monday of that week in a seperate colum any advise please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
week No to date
Hello Jon,
As given by some guy called daddylonglegs: [citation from http://www.excelforum.com/excel-gene...e-weeknum.html ] =DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3)) A1: Year A2: Weeknum in year (ISO) Regards, Bernd |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
week No to date
Sorted Ta
"Bernd P" wrote: Hello Jon, As given by some guy called daddylonglegs: [citation from http://www.excelforum.com/excel-gene...e-weeknum.html ] =DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3)) A1: Year A2: Weeknum in year (ISO) Regards, Bernd . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
