On reflection that was a bit misleading because it isn't always a -1 value so
i'll do it for your. The numbers are

-1 fri
0 sat
1 sun
2 mon
3 tue
4 wed
5 thu

Mike
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H" wrote:

Hi,

With a properly formatted date in a1 try this and drag down for the Fridays
of that month in A1

The key to Getting the other days of the weekdays lies in the -1 in this bit
of the formula
ROWS(A$1:$A1)*7)-1
Change the -1 to different values (It appears 3 times) and you'll figure it
out

=IF(MONTH(($A$1-WEEKDAY($A$1,1))+(ROWS(A$1:$A1)*7)-1)<MONTH($A$1),(($A$1+7-WEEKDAY($A$1+7,1))+(ROWS(A$1:$A1)*7)-1),($A$1-WEEKDAY($A$1,1))+(ROWS(A$1:$A1)*7)-1)



--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"MasterDragon" wrote:

MY question is simple, sorry if i'm being stupid.

Can anyone tell me how can i make a list which contains only dates of all
the Fridays in a particular month?

In a more advanced sense, can I create a list with all the Fridays AND
Saturdays of a month?