rpaulson
Well-known Member
- Joined
- Oct 4, 2007
- Messages
- 1,378
Hello all,
not as easy as it sounds
we use weeks that start on Monday as the first day of the week. therefore in our WEEKNUM formula we use type 21. example =WEEKNUM (A1, 21).
there are times wen the week number will wrap thru a year change.
I'm looking for a formula or VBA option to get the start and end of the week if I supply the year and the week. (See sample).
A1=2022
A2=13
should fetch March 28, 2022 and April 3 2022
-Ross
not as easy as it sounds
we use weeks that start on Monday as the first day of the week. therefore in our WEEKNUM formula we use type 21. example =WEEKNUM (A1, 21).
there are times wen the week number will wrap thru a year change.
I'm looking for a formula or VBA option to get the start and end of the week if I supply the year and the week. (See sample).
A1=2022
A2=13
should fetch March 28, 2022 and April 3 2022
-Ross