| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate month from week number
I need to be able to calculate the month from a week number entered onto a worksheet. i.e. week Month 1 Jan 2 Jan 3 Jan 4 Jan 5 Feb A sumif statement will then be used to extract data from another worksheet based on Month returned. (The months on the other worksheet are in text format) Can anyone help? I'm stumped! Thanks Guys -- ankman ------------------------------------------------------------------------ ankman's Profile: http://www.excelforum.com/member.php...o&userid=16796 View this thread: http://www.excelforum.com/showthread...hreadid=319938 |
|
#2
|
|||
|
|||
|
See the web site: http://www.pvv.org/~nsaa/ISO8601.html
They have some examples. "ankman" wrote in message ... I need to be able to calculate the month from a week number entered onto a worksheet. i.e. week Month 1 Jan 2 Jan 3 Jan 4 Jan 5 Feb A sumif statement will then be used to extract data from another worksheet based on Month returned. (The months on the other worksheet are in text format) Can anyone help? I'm stumped! Thanks Guys -- ankman ------------------------------------------------------------------------ ankman's Profile: http://www.excelforum.com/member.php...o&userid=16796 View this thread: http://www.excelforum.com/showthread...hreadid=319938 |
|
#3
|
|||
|
|||
|
This works too. Cell A14 has the week number. Cell B14 has the year.
Returns the date of the Monday of that week. =DATE(B14,1,1)+((A14-1)*7)-WEEKDAY(DATE(B14,1,1)+(A14-1)*7,2)+1 -BV "ankman" wrote in message ... I need to be able to calculate the month from a week number entered onto a worksheet. i.e. week Month 1 Jan 2 Jan 3 Jan 4 Jan 5 Feb A sumif statement will then be used to extract data from another worksheet based on Month returned. (The months on the other worksheet are in text format) Can anyone help? I'm stumped! Thanks Guys -- ankman ------------------------------------------------------------------------ ankman's Profile: http://www.excelforum.com/member.php...o&userid=16796 View this thread: http://www.excelforum.com/showthread...hreadid=319938 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get week number in month in excel ? | Charts and Charting in Excel | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Linear Mode
