I have 2 worksheets that inputs the current month using =NOW() function (Month worksheet). A second worksheet (2ndWED) that calculates the second Wednesday of the month.
How can I get the correct data from “2ndWED” into “Month”?
Or is there an “easier” way to go about this.
Thank ahead for any help or solution.
2nd Wednesday.ods (12.5 KB)
You could skip the second sheet entirely =WORKDAY.INTL(EOMONTH(B1;-1);2;"1011111")+1
Per your suggestion, somehow I get May 15 (the 3rd Wednesday) instead of May 8 for the second Wednesday. How can I fix this?
2nd Try.ods (11.9 KB)
So it does. Maybe using Thursday as weekend works better than Tuesday
=WORKDAY.INTL(EOMONTH(B1;-1);2;"1110111")-1
Guess what, I change it to =…“1101111”) drop the -1 and it work. I’ll confirm it next month when the “month” change to June. Thank you.
Not sure I’d go about it like this. But to just finish up what you’ve got, on the “Month” sheet in cell B2 put this:
=VLOOKUP(DATE(YEAR(B1),MONTH(B1),1),$2ndWED.A2:B13,2,0)
This just splits Y/M/D from the Now() in B1 then recomposes a new date with the 1st of the month for the day. After that, it looks up this number in the table on the 2ndWed sheet.
Thanks, it does work fine, I’m just waiting to hear back from EarnestAl for his idea does away with the second sheet before I check off the solution.