Date Calculation Problem

R

RFrechette

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
 
L

lurker111

I'm not sure about the workings of the "Workday" function but if you notice
something here: 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.
 
D

Dave O

The WORKDAY function returns the first weekday date that is the
specified number of days from your start date. When your start date is
in the middle of the week, your formula returns the next day- when that
day is a weekday. The August and October dates are on a weekend or a
Friday, so they don't return the next day, they return the next soonest
weekday- that's what the WORKDAY function does.

If you would like to return the next day's date, regardless of
weekday/weekend, you can simply use
=A5+1
for example.

What are you trying to do? It may be a matter of using another formula.
 
R

RFrechette

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
 
R

RFrechette

I figured it out. I was using the correct formula and it was actually doing
what I wanted.

Like I told Lurker111, I'm an idiot. Must be because it's a couple of hours
before the holiday begins...

Thanks for your response.

Rachel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top