On Tue, 6 Jan 2009 14:19:02 -0800, Cutie
wrote:

How do I calculate 6 working days from any date. e.g. 5th January 2009 is my
starting date, what formula to I use to work out 6 days excluding weekend.
Thank you

With Jan 5 in A1, use something like:

=workday(a1,5)

If you get a #NAME! error, look at HELP for the Workday function for how to
resolve it.

The Workday function also has an optional [holidays] argument which you may
find useful.
--ron