Hi Lisa
I would like to have cells A1-A20 to have the dates of every Mon Wed
and Fri, ie
9/24/07
9/26/07
9/28/07
10/1/07
10/3/07
10/5/07
That's a tricky one! The only way that I can think of doing it is with a
formula.
Put the first date in A1, then put the following formula in the rest of
the cells. Make sure they're all formatted as dates.
Here is the formula:
=H12+2+(WEEKDAY(H12)=6)
I hope this helps.
Adrian
www.tryanotherangle.org
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
