Help with Date Function
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?
|