How to compute date of next weekday?
 

Suppose D3 contains some date (e.g. 7/11/2008).

What's the "best" way to compute the date of the next weekday
(7/14/2008)?

Currently, I am using the following array formula:

=MIN( IF( WEEKDAY(D3+ROW($1:$3), 2) <= 5, D3+ROW($1:$3) ) )

It works fine. But is there a better formula?

I would prefer a non-array formula.

PS: I am using Excel 2003.

How to compute date of next weekday?
 

On Wed, 30 Jul 2008 16:04:12 -0700 (PDT), wrote:

Suppose D3 contains some date (e.g. 7/11/2008).

What's the "best" way to compute the date of the next weekday
(7/14/2008)?

Currently, I am using the following array formula:

=MIN( IF( WEEKDAY(D3+ROW($1:$3), 2) <= 5, D3+ROW($1:$3) ) )

It works fine. But is there a better formula?

I would prefer a non-array formula.

PS: I am using Excel 2003.

If you have the Analysis Tool Pak installed, you can use:

=WORKDAY(A1,1)

For instructions on how to install the ATP, see HELP for the WORKDAY function.
--ron

How to compute date of next weekday?
 

Hi curiousgeorge
=WORKDAY(d3) ???

Regards,
Pedro J.

Suppose D3 contains some date (e.g. 7/11/2008).

What's the "best" way to compute the date of the next weekday
(7/14/2008)?

Currently, I am using the following array formula:

=MIN( IF( WEEKDAY(D3+ROW($1:$3), 2) <= 5, D3+ROW($1:$3) ) )

It works fine. But is there a better formula?

I would prefer a non-array formula.

PS: I am using Excel 2003.

How to compute date of next weekday?
 

On Jul 30, 4:32*pm, Ron Rosenfeld wrote:
=WORKDAY(A1,1)

Klunk! I thought something like that existed. But when I didn't see
it in the See Also list for WEEKDAY, I gave up. Sigh, I shoulda
looked at the complete Data and Time Functions list.

Thanks.

How to compute date of next weekday?
 

On Wed, 30 Jul 2008 17:01:28 -0700 (PDT), wrote:

On Jul 30, 4:32*pm, Ron Rosenfeld wrote:
=WORKDAY(A1,1)

Klunk! I thought something like that existed. But when I didn't see
it in the See Also list for WEEKDAY, I gave up. Sigh, I shoulda
looked at the complete Data and Time Functions list.

Thanks.

Glad to help. Thanks for the feedback.
--ron