excel - Determine the month of a week based on in which month a certain weekday is? -
excel - Determine the month of a week based on in which month a certain weekday is? - i want user come in year a1. i want user come in week number a2. i want user come in weekday (monday, tuesday, wednesday, thursday, friday, saturday or sunday) in a3. then want a4 calculate month of entered week number weeks counted belonging month depending on if specified weekday in month or not. what formula work in a4? (if can not solve problem, can give me formula works if specified weekday can thursday, welcome well. my thought that: (weeknumber-1)*7 + weekday -> mon = 1, tue = 2.... check day of year [0..365 or 366] , compare offset jan / feb / march... depending on whether year has 29th of feb - can calculated using year. now have convert code. edit: after read page reffered to, assume have problem understanding excels date syntax http://office.microsoft.com/en-us/excel-help/date-function-hp010062283.aspx so lets break code down: happens here? =choose(mo...