Workday return a Saturday date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jessie - 22 Mar 2007 03:19 GMT

Hi,

I used a workday function in my worksheet but the result returns a date on
Saturday... I don't know what I did wrong. I am using excel 2003.

I was trying to calculate the date before month end, say March 31, 2007
=workday(date(2007,3,31),0) and it returns 3/31/2007 which is a Saturday.
But I want 3/30/2007 as the last working date before the end of the month.

Can anyone help me?

Signature

Jessie

Reply to this Message

Niek Otten - 22 Mar 2007 09:47 GMT

Hi Jessie,

=WORKDAY(DATE(2007,4,1),-1)

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 6 lines]
|
| Can anyone help me?

Reply to this Message

Bob Phillips - 23 Mar 2007 20:47 GMT

Maybe

=WORKDAY(DATE(2007,3,31)+1,-1)

if he wants today unless it is a weekend date

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi Jessie,
>
[quoted text clipped - 13 lines]
> |
> | Can anyone help me?

Reply to this Message