Remember Me?

#1
September 27th 09, 12:31 AM
 Junior Member First recorded activity by ExcelBanter: Apr 2005 Location: Ireland Posts: 29
Return the first Wednesday of each month

If I put a date in cell A1 (1/1/2010) how do I get the first wednesday in each month in 2010 to display in cells A2:A13 i.e
6/1/2010
3/2/2010
3/3/2010 etc.?

#2
September 27th 09, 02:37 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 3,718
Return the first Wednesday of each month

=DATE(YEAR(A1),MONTH(A1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))

"dalymjl" wrote:

If I put a date in cell A1 (1/1/2010) how do I get the first wednesday
in each month in 2010 to display in cells A2:A13 i.e
6/1/2010
3/2/2010
3/3/2010 etc.?

--
dalymjl

#3
September 27th 09, 02:57 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 3,718
Return the first Wednesday of each month

In A2:
=DATE(YEAR(A1),MONTH(A1)+MIN(1,ROWS(\$1:1)-1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+MIN(1,ROWS(\$1:1)-1),4))

copy down to A13

"dalymjl" wrote:

If I put a date in cell A1 (1/1/2010) how do I get the first wednesday
in each month in 2010 to display in cells A2:A13 i.e
6/1/2010
3/2/2010
3/3/2010 etc.?

--
dalymjl

#4
September 27th 09, 05:10 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Return the first Wednesday of each month

Try this...

Enter this formula in A2. This will return the 1st Wednesday of the month
for the date entered in A1.

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)-3)

Enter this formula in A3 and copy down as needed. This will return the 1st
Wednesday date for the subsequent months.

=A2+28+((DAY(A2+35)<8)*7)

Format as Date

--
Biff
Microsoft Excel MVP

"dalymjl" wrote in message
...

If I put a date in cell A1 (1/1/2010) how do I get the first wednesday
in each month in 2010 to display in cells A2:A13 i.e
6/1/2010
3/2/2010
3/3/2010 etc.?

--
dalymjl

#5
September 27th 09, 06:53 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 806
Return the first Wednesday of each month

Hello,

A general formula:
http://www.sulprobil.com/html/weekday_in_month.html

Regards,
Bernd

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post J Excel Worksheet Functions 2 June 30th 09 09:26 AM cainart New Users to Excel 13 July 25th 07 12:50 PM sam76210 Excel Discussion (Misc queries) 0 March 8th 06 05:05 PM Millerk Excel Discussion (Misc queries) 2 March 2nd 06 07:23 PM JJalomo Excel Worksheet Functions 12 May 18th 05 03:52 PM

All times are GMT +1. The time now is 08:56 AM.