I just realized that myself.

You know, I checked that for the Aug. dates and ended up looking at the
wrong month.

I'm an idiot!

Thank you for your quick response.

Rachel

"lurker111" wrote:

I'm not sure about the workings of the "Workday" function but if you notice
something he 8/18 is a Friday, 8/21 is a Monday. 8/12 is a Saturday,
8/14 is a Monday. 10/07 is a Saturday, 10/09 is a Monday. 9/19 is a
Tuesday. 11/01 is a Wednesday.

It would seem to me that the Workday function will only give results from
Monday through Friday (the standard work week). Therefore if you put in 8/17
it should result in 8/18.

"RFrechette" wrote:

This one is really stumping me...

I have a spreadsheet that contains a column of dates, the next column should
calculate that date plus 1 day. I only want workdays.

My formula is: =WORKDAY(A5,1)

I'm getting:

Column A Column B
Open Date/Time Close Date/Time
09/19/2006 2:19 PM 09/20/2006 12:00 AM
08/18/2006 12:41 PM 08/21/2006 12:00 AM
11/01/2006 8:25 AM 11/02/2006 12:00 AM
08/12/2006 11:40 AM 08/14/2006 12:00 AM
10/07/2006 12:20 PM 10/09/2006 12:00 AM

The dates in Sept and Nov are working. The dates with Aug and Oct are not.
(They are adding more than 1 day.) They all have the same formula and the
formats are all the same.

What could I be missing here?

Thank you,

Rachel