| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get date from WEEK No.
Hi ,
I am using a Formula from Chip Pearson that will give the WEEK No. (ISO) for an entered date. Is there a way to enter a WEEK No. (and year) and get the date of the Monday in that Week Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get date from WEEK No.
Hi,
Week number in A1 and a year in a2 =DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+1 Mike "Francois via OfficeKB.com" wrote: Hi , I am using a Formula from Chip Pearson that will give the WEEK No. (ISO) for an entered date. Is there a way to enter a WEEK No. (and year) and get the date of the Monday in that Week Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get date from WEEK No.
Mike H wrote:
Hi, Week number in A1 and a year in a2 =DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+1 Mike Hi , [quoted text clipped - 5 lines] Thanks Excellent, Thanks a lot -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get date from WEEK No.
Your welcome
"Francois via OfficeKB.com" wrote: Mike H wrote: Hi, Week number in A1 and a year in a2 =DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+1 Mike Hi , [quoted text clipped - 5 lines] Thanks Excellent, Thanks a lot -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
| 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
