next three business days

[Chenboy2]

I'm trying to make a formula that will display in the cell what day (MM/DD/YYYY) it will be in three business days from today.

Example
If cell A1 displays today, 11/05/2010, then cell A2 would display three business days would be Wednesday 11/10/2010. I don't want to include weekends as part of the days.

(I don't want to use any programming languages to come up with this formula.)

 

[shg]

=workday(today(), 3)

 

[VoG]

Try

=WORKDAY(A1,3)

 

[Chenboy2]

How do you convert the number into date format?

 

[Chenboy2]

Nevermind, I figured it out.
Thanks.

 

[VoG]

Press CTRL + 1. Format the cell as Date.