date
Posted by mcarter973 on September 19, 2001 9:39 AM
is there a way to list just the weekdays of the month? taking that question one step further, can i also exclude holidays? currently, i use the prior day +1 but for monday, i use prior day + 3 (because a weekend is involved).
example:
a1: 9/6
a2: 9/7 (a1+1)
a3: 9/10 (a2+3)
Posted by IML on September 19, 2001 9:49 AM
Partial answer
assuming you put a m-f date in A1, use the following in A2 and below:
=+A1+1+(WEEKDAY(A1)=6)*2
This doesn't address your holidays, though.
good luck
Posted by Eric on September 19, 2001 10:24 AM
Also check out the WORKDAY function that comes with the analysis tool pak (NT)
Posted by Mark W. on September 19, 2001 11:00 AM
To elaborate on Eric's 'Most Excellant' suggestion...
A1: 9/6
A2: =WORKDAY(A1,1)
...select cell A2 and drag down as far as needed.
Holidays can be listed in the WORKDAY function's
3rd, optional paramter as shown below:
=WORKDAY(A1,1,{"9/3/01","11/23/01","12/25/01"}+0)
Posted by mcarter973 on September 19, 2001 11:51 AM
Thanks Mark - your suggestion worked perfectly.
