How to get dates of each Friday in a month

[sateeshruttala]

Hi ,

Can i get a dates of each Friday in a month.

For example June 2016.

i want only dates like this 3,10,17,24 .

Thanks

Sateesh

[Tony Valko]

Try this...

Enter the 1st of the month date in cell A1:

A1 = 6/1/2016

Data Range

	A	B	C
1	6/1/2016	6/3/2016	Fri
2		6/10/2016	Fri
3		6/17/2016	Fri
4		6/24/2016	Fri
5	------	------	------

Enter this formula in B1:

=WORKDAY.INTL(EOMONTH(A1,-1),1,"1111011")

Format as Date

Enter this formula in B2 and copy down to B5:

=IF(MONTH(B$1+ROWS(B$2:B2)*7)=MONTH(B$1),B1+7,"")

Format as Date

[sateeshruttala]

thanks a lot that worked well

[Tony Valko]

You're welcome. Thanks for the feedback!