privatemoon
New Member
- Joined
- Feb 15, 2013
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to get the date for the second Wednesday of the month. The formula I currently have is:
=DATE(YEAR(NOW()),MONTH(NOW()),1+7*2)-WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),8-4))
However, that gives me 9/8/21 for this month, which is the first Wednesday of the month. Any help will be appreciated, thanks!
I'm trying to get the date for the second Wednesday of the month. The formula I currently have is:
=DATE(YEAR(NOW()),MONTH(NOW()),1+7*2)-WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),8-4))
However, that gives me 9/8/21 for this month, which is the first Wednesday of the month. Any help will be appreciated, thanks!