Work Days in cells

[gunmetal]

This should be pretty simple for you guys

I just need work days posted like this in my monthly report

beginning with

7/29/2010
7/30/2010
8/2/2010
8/3/2010
8/4/2010
8/5/2010
8/6/2010
8/9/2010

and so on I have posted the links below to the actual document. Oh If you could not use the NOW() function because I need to input data from the 29th and 30th.. Thanks in advance

[teylyn]

Hello,
make sure you have the Analysis ToolPak enabled.

Then manually enter the first date into A2
In A3 enter

=WORKDAY(L2,1)

format as date and copy down.

[DonkeyOte]

WORKDAY has obvious advantages in so far as it is easy to handle public holidays should you need to - if you don't you could equally use standard:

A3: =A2+LOOKUP(WEEKDAY(A2,2),{0,5},{1,3})
copied down

(you can still account for public holidays without resorting to ATP but ATP makes life a whole lot easier)

note: small typo in Teylyn's prior post - reference in WORKDAY is meant to be A2