How to list dates in a month of particular weekday
On Sat, 23 Jan 2010 16:41:04 -0500, Ron Rosenfeld
wrote:
B1:
=IF(MONTH($A$1-DAY($A$1)+8-WEEKDAY($A$1-DAY($A$1)+2)+
(ROWS($1:1)-1)*7)<MONTH($A$1),"",$A$1-DAY($A$1)+8-
WEEKDAY($A$1-DAY($A$1)+2)+(ROWS($1:1)-1)*7)
This tests to make sure the month output is the same as the month of A1.
The same, obviously, would apply for Saturdays.
Forgot to state to "fill down" at least five rows.
--ron
|