| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Particular Day of Month
Is there a way to find the second Wednesday of each month using Excel
97? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding Particular Day of Month
Try
=DATE(YEAR(A1),MONTH(A1),15)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4)) where A1 holds any day of the particular month you want to check for -- Regards, Peo Sjoblom "DF" wrote in message ups.com... Is there a way to find the second Wednesday of each month using Excel 97? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding Particular Day of Month
=11-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1))+DATE (YEAR(TODAY()),MONTH(TODAY()),1)
"DF" wrote: Is there a way to find the second Wednesday of each month using Excel 97? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding Particular Day of Month
On 18 Apr 2007 08:54:16 -0700, DF wrote:
Is there a way to find the second Wednesday of each month using Excel 97? With some date in the month of concern in A1, try: =A1-DAY(A1)+15-WEEKDAY(A1-DAY(A1)+4) --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding Particular Day of Month
|
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding Particular Day of Month
"DF" wrote in message
... In article . com, DF wrote: Is there a way to find the second Wednesday of each month using Excel 97? Hey, it works!! I tried the formulas given by Peo Sjoblom and Ron Rosenfeld and both work equally as well. The third formula given by whomever, works but only for the current month. Thanks for your help. This is neat. Did you try replacing TODAY() in that third formula by A1? -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help finding the date of the last Saturday of a given month | Excel Worksheet Functions | |||
| Finding the number of Days in the month? | Excel Discussion (Misc queries) | |||
| Finding the last day of a month | Excel Discussion (Misc queries) | |||
| Finding the Sum of value each month | Excel Discussion (Misc queries) | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
Hybrid Mode
