How do I fill a column's cells with a year's worth of weekdays only?
TIA
How do I fill a column's cells with a year's worth of weekdays only?
TIA
Enter the first date. Right-click the fill handle in the lower right
corner of the cell and drag down about 270 rows. Choose Fill Weekdays
from the menu that pops up when you release the mouse.
In article <[email protected]>,
DJ Bjorklund <[email protected]> wrote:
> How do I fill a column's cells with a year's worth of weekdays only?
> TIA
Set 1ste weekday in H29 (in 2005 : "03/01/2005")
then in h30->h(as much as you like):
=IF(WEEKDAY(H29;2)=6;H29+3;IF(WEEKDAY(H29;2)=7;H29+2;H29+1))
OK ?
Gilbert
"DJ Bjorklund" <[email protected]> wrote in message
news:[email protected]...
> How do I fill a column's cells with a year's worth of weekdays only?
> TIA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks