software

I'm creating an excel spreadsheet and need to add business days only. If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1 5 business
days, no weekends?

See HELP for the NETWORKDAYS function

--
Kind regards,

Niek Otten

quot;Ozzyquot; gt; wrote in message ...
gt; I'm creating an excel spreadsheet and need to add business days only. If
gt; cell a1 is todays date (3/20/06), how do I make cell b1 equal a1 5 business
gt; days, no weekends?
On Tue, 21 Mar 2006 13:41:28 -0800, Ozzy gt;
wrote:

gt;I'm creating an excel spreadsheet and need to add business days only. If
gt;cell a1 is todays date (3/20/06), how do I make cell b1 equal a1 5 business
gt;days, no weekends?=WORKDAY(A1,5)

Check HELP for the WORKDAY function. There is an optional Holidays argument.
If you get a NAME error, you need to install the Analysis Tool Pak. This is
outlined in the HELP topic for the WORKDAY function.
--ron