Find date of 3rd Wed of month
Sorry, my mistake, plugged the wrong year in.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob Phillips" wrote in message news:... I don't think this works if the 1st day of the month is a Wed. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rick Rothstein" wrote in message ... Try this formula.... =DATE(YEAR(A1),MONTH(A1),22)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4)) where A1 is assumed to contain any date within the month of interest. Of course, you may substitute the direct year and month for both of the YEAR(A1) and MONTH(A1) function calls. -- Rick (MVP - Excel) "Chuck" wrote in message ... How can I find the date (number) of the third wednesday of a month? Chuck |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com