Could someone help me with a formula that will take the date in column A and return the week number of the month in column B, based on this range:
day of the month week of the month 1st-7th 1 8th-14th 2 15th-21st 3 22nd-29th 4 30th-31st 5
e.g.
A B 1 03/01/2016 1 2 14/01/2016 2 3 17/01/2016 3 4 30/01/2016 5
Bookmarks