Re: Auto Fill days of the month (not including weekends)
- From: "Bob Phillips" <bob.ngs@xxxxxxxxxxxxx>
- Date: Mon, 2 Jul 2007 15:33:52 +0100
put the date of the last day of the previous month in A1, and in B1 enter
=IF(WEEKDAY(A1)=7,2,1)+A1
in C1 enter
=IF(MONTH(B1+1)<>MONTH(B1),"",IF(WEEKDAY(B1)=7,2,1)+B1)
and copy across
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"John Krsulic" <JohnKrsulic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82AD7C1C-0FC4-4DDD-A099-FA425C6C9147@xxxxxxxxxxxxxxxx
I need to create a sheet where the days of the month show accross the top
of
the columns. I have been starting with the first day of the month and auto
filling to the last day and then manually going in and deleting out the
weekends. Is there a way to create a formula where I can auto fill but not
have it include the weekends.
My heading should be July 2 July 3 July 4 July 5 July 6 July 9
.
- Prev by Date: Re: Showing Cummulative Top5 results with an array-formula...?
- Next by Date: Re: Auto Fill days of the month (not including weekends)
- Previous by thread: URGENT: Using Named Ranges with Chart Wizard
- Next by thread: Re: Auto Fill days of the month (not including weekends)
- Index(es):
Relevant Pages
|
