Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find date of 3rd Wed of month | Excel Programming | |||
Find date of first Monday of each month | Excel Discussion (Misc queries) | |||
How can I find out what date going to be 3 month from today in ex | Excel Worksheet Functions | |||
find date of last weekday of a month | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) |