By the way, I gave you a solution for your second question; however, if you
only wanted to list the Fridays by themselves, use the same formula I gave
you for B1, but use the formula I gave you for B3 in B2 instead and then
copy it down.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
You didn't post a lot of detail about your setup. Assuming the month
number is in A1 and your list of Fridays and Saturdays is to be listed in
Column B starting at B1, put these formulas in the indicated cells...

B1: =DATE(YEAR(NOW()),$A$1,8)-WEEKDAY(DATE(YEAR(NOW()),$A$1,2))
B2: =DATE(YEAR(NOW()),$A$1,8)-WEEKDAY(DATE(YEAR(NOW()),$A$1,1))
B3: =IF(B1="","",IF(MONTH(B1+7)=$A$1,B1+7,""))

And then copy down the formula that is in B3 down to B10.

--
Rick (MVP - Excel)


"MasterDragon" wrote in message
...
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?