Menu
If I have week 7 in 2017 what week date is the Monday in that week in Google Sheets?
654
In the US, where the first day of the week is Sunday, the modified formula is: =DATE(B9,1,1)+(A9-1)*7-(WEEKDAY(DATE(B9,1,1)))+2 (As above, this assumes the year is in B9 and the week number in A9.)
How do you use WEEKNUM in Google Sheets? In the formula, "serial_number" is the cell reference for the date that you want to calculate the week number for. After you've entered the formula, press "Enter" on your keyboard and the week number for the date will be displayed in the cell.
WEEKDAY returns the day of week in numeric form, not as a letter (e.g. 'M' or 'F') an abbreviation (e.g. 'Tue' or 'Thu') nor as a full day name (e.g. 'Wednesday'). To get the name of the weekday, use the TEXT function or change the number formatting on the cell.
=DATE(B9,1,1)-WEEKDAY(DATE(B9,1,1),3)+7*(WEEKDAY(DATE(B9,1,1),3)>3)+7*(A9-1) is the least complicated formula I know which works for week numbers in Sweden (i.e. Monday first day of week, ISO rules for what is week 1).
159
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
