-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Which Wednesday is closest to the 15th day of a given month?
- Thread starter eduzs
- Start date
shg
MrExcel MVP
- Joined
- May 7, 2008
- Messages
- 21,836
- Office Version
- 2010
- Platform
- Windows
Date | Closest Wed | |
Fri 15 Jan 2016 | Wed 13 Jan 2016 | B2: =A2 - WEEKDAY(A2) + 4 |
Mon 15 Feb 2016 | Wed 17 Feb 2016 | |
Tue 15 Mar 2016 | Wed 16 Mar 2016 | |
Fri 15 Apr 2016 | Wed 13 Apr 2016 | |
Sun 15 May 2016 | Wed 18 May 2016 | |
Wed 15 Jun 2016 | Wed 15 Jun 2016 | |
Fri 15 Jul 2016 | Wed 13 Jul 2016 | |
Mon 15 Aug 2016 | Wed 17 Aug 2016 | |
Thu 15 Sep 2016 | Wed 14 Sep 2016 | |
Sat 15 Oct 2016 | Wed 12 Oct 2016 | |
Tue 15 Nov 2016 | Wed 16 Nov 2016 | |
Thu 15 Dec 2016 | Wed 14 Dec 2016 |
Upvote
0
