Forum

Robert Bigler
@bob-bigler98
New Member
Joined: Mar 2, 2017
Topics: 0 / Replies: 1
Reply
RE: Calculate the month from the week number

=MONTH(DATE(YEAR(NOW()),1,1)+21*7-1) converts 21 weeks to month 5, based on the current year. Change the 21 to a cell reference of the number of we...

7 years ago