cell A4 is date
cell B2 is =WEEKNUM($A4,11)
I am using this formula
=WORKDAY.INTL($A4,B$2,"0111111")
which works fine when the start date in cell A4 as 1 Jan 2021,
if this date is changed to other dates for example 1 Feb 2021 the result is not as desired (need Monday)
Kindly see the attached file.
Thank you.
Bookmarks