As the crane-fly said

=WORKDAY(A1+1,3)-1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Greg" wrote in message
...
It's not so simple.
For example Wednesday+3 will give Monday,
but I need Sunday

"VBA Noob" wrote:


Not sure if I follow you.

If A1 = thursday do you want to drag down a list of dates excluded Fri
and Sat. If this is the case then put this formula into cell A2 and
drag down

=IF(OR(WEEKDAY(A1+1)=6,WEEKDAY(A1+1)=7),A1+3,A1+1)

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=566388