Prev: Search Macro
Next: Search Macro - Command Button
From: mdj0615 on 21 Apr 2010 08:44
I have tried, and I can't figure out if this is possible. I'm trying to have
dates autofill into a row of columns (C5 to V5 to be specific). I don't want
week-end days to be a part of the autofill, and I can't figure out the
formula. Any suggestions?
From: Mike H on 21 Apr 2010 08:52
Hi,

Enter the first date in C5 which must be a weekday then put the formula
below in D5 and drag right

=C5+CHOOSE(WEEKDAY(C5),0,1,1,1,1,3)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mdj0615" wrote:

> I have tried, and I can't figure out if this is possible. I'm trying to have
> dates autofill into a row of columns (C5 to V5 to be specific). I don't want
> week-end days to be a part of the autofill, and I can't figure out the
> formula. Any suggestions?
From: Duke Carey on 21 Apr 2010 09:00
In addition to Mike's suggestion, there is a WORKDAY() function that will
skip holidays that you list in a range and reference in the function.

If you have Excel 2007, you can use WORKDAY() directly. In earlier versions
(I think) you have to go to Tools->Add-ins and make sure the Analysis Toolpak
is checked.

"mdj0615" wrote:

> I have tried, and I can't figure out if this is possible. I'm trying to have
> dates autofill into a row of columns (C5 to V5 to be specific). I don't want
> week-end days to be a part of the autofill, and I can't figure out the
> formula. Any suggestions?
From: RagDyeR on 21 Apr 2010 11:43
You really don't need a formula.
XL has this feature built in!

Enter a date in a cell, and then drag with the *right* mouse button.

When you release the mouse, you're given a number of choices for the fill,
one of them being ""Weekdays".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"mdj0615" <mdj0615(a)discussions.microsoft.com> wrote in message
news:91F3E437-E4EB-4E52-9AD3-A7CDF28F675A(a)microsoft.com...
I have tried, and I can't figure out if this is possible. I'm trying to
have
dates autofill into a row of columns (C5 to V5 to be specific). I don't
want
week-end days to be a part of the autofill, and I can't figure out the
formula. Any suggestions?


 | 
Pages: 1
Prev: Search Macro
Next: Search Macro - Command Button