With the first date in A1, put this formula in A2:
=A1+CHOOSE(WEEKDAY(A1),1,2,1,1,3,2,1)
On Thu, 31 Mar 2005 04:37:05 -0800, "MichaelSedley"
wrote:
Hi,
I'm trying to create a column which automatically shows all the Sundays,
Mondays, Wednesdays and Thursdays in a month (skipping Tuesdays, Fridays,
Saturdays).
Is this possible?
|